Available now! Telegram Research 2025 — the year's key insights 
SQL задачи
SQL задачи для подготовки к собеседованию. SQL тесты для проверки знаний. № 7065181110 SQL запросы к конкретной Базе данных с решением и разбором По вопросам рекламы: @anothertechrock
Show more📈 Analytical overview of Telegram channel SQL задачи
Channel SQL задачи (@sqlquestions) in the Russian language segment is an active participant. Currently, the community unites 10 055 subscribers, ranking 12 169 in the Technologies & Applications category and 64 937 in the Russia region.
📊 Audience metrics and dynamics
Since its creation on невідомо, the project has demonstrated rapid growth, gathering an audience of 10 055 subscribers.
According to the latest data from 23 June, 2026, the channel demonstrates stable activity. Although there has been a change in the number of participants by -30 over the last 30 days and by 0 over the last 24 hours, overall reach remains high.
- Verification status: Not verified
- Engagement rate (ER): The average audience engagement rate is 13.73%. Within the first 24 hours after publication, content typically collects 5.73% reactions from the total number of subscribers.
- Post reach: On average, each post receives 1 381 views. Within the first day, a publication typically gains 576 views.
- Reactions and interaction: The audience actively supports content: the average number of reactions per post is 5.
- Thematic interests: Content is focused on key topics such as sql, sqlquestions, шапка, order_table, архитектура.
📝 Description and content policy
The author describes the resource as a platform for expressing subjective opinions:
“SQL задачи для подготовки к собеседованию.
SQL тесты для проверки знаний.
№ 7065181110
SQL запросы к конкретной Базе данных с решением и разбором
По вопросам рекламы: @anothertechrock”
Thanks to the high frequency of updates (latest data received on 24 June, 2026), the channel maintains relevance and a high level of publication reach. Analytics show that the audience actively interacts with content, making it an important point of influence in the Technologies & Applications category.
SELECT SUBSTRING(email, 1, LOCATE('@', email) - 1) FROM customer WHERE customer_id = 1;SELECT first_name, last_name, allergies FROM patients WHERE allergies IN ('Penicillin', 'Morphine') ORDER BY allergies, first_name, last_name;
patients имена и фамилии пациентов, имеющих аллергию на пенициллин или морфин ("Penicillin", "Morphine"), а также названия препаратов, на которые у них аллергия. Т.е. выводим значения столбцов first_name, last_name и allergies.
Выведите результаты, отсортированные в порядке возрастания сперва по препаратам, вызывающим аллергию, затем по именам, затем по фамилиям.
#задача
SELECT gender, COUNT(*) FROM customer GROUP BY gender HAVING COUNT(*) < 5;
SELECT * FROM orders ORDER BY ord_date,purch_amt DESC;
ord_date (в порядке возрастания) и по purch_amt (в порядке убывания). Верните все поля.
#задача
SELECT allergies, COUNT(*) AS total_diagnosis FROM patients WHERE allergies IS NOT NULL GROUP BY allergies
ORDER BY total_diagnosis DESC;
patients все аллергии (allergies), упорядоченные по их количеству (total_diagnosis - тоже вывести). Удалите из запроса значения NULL.
#задачаSELECT category_id, AVG(price)
FROM product
GROUP BY category_id
HAVING AVG(price) > 200;
