Data Science & Machine Learning
Join this channel to learn data science, artificial intelligence and machine learning with funny quizzes, interesting projects and amazing resources for free For collaborations: @love_data
Show more๐ Analytical overview of Telegram channel Data Science & Machine Learning
Channel Data Science & Machine Learning (@datasciencefun) in the English language segment is an active participant. Currently, the community unites 75 802 subscribers, ranking 2 117 in the Education category and 4 312 in the India region.
๐ Audience metrics and dynamics
Since its creation on ะฝะตะฒัะดะพะผะพ, the project has demonstrated rapid growth, gathering an audience of 75 802 subscribers.
According to the latest data from 16 June, 2026, the channel demonstrates stable activity. Although there has been a change in the number of participants by 924 over the last 30 days and by 38 over the last 24 hours, overall reach remains high.
- Verification status: Not verified
- Engagement rate (ER): The average audience engagement rate is 3.47%. Within the first 24 hours after publication, content typically collects 1.42% reactions from the total number of subscribers.
- Post reach: On average, each post receives 2 629 views. Within the first day, a publication typically gains 1 075 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 learning, accuracy, distribution, panda, dataset.
๐ Description and content policy
The author describes the resource as a platform for expressing subjective opinions:
โJoin this channel to learn data science, artificial intelligence and machine learning with funny quizzes, interesting projects and amazing resources for free
For collaborations: @love_dataโ
Thanks to the high frequency of updates (latest data received on 17 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 Education category.
SELECT employee_id, name
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);
In this case, the subquery calculates the average salary, and the outer query selects employees whose salary is greater than the average.
7. What is the difference between a UNION and a UNION ALL?
- UNION combines the result sets of two SELECT statements and removes duplicates.
- UNION ALL combines the result sets and includes duplicates.
8. What is the difference between WHERE and HAVING clause?
- WHERE filters rows before any groupings are made. Itโs used with SELECT, INSERT, UPDATE, or DELETE statements.
- HAVING filters groups after the GROUP BY clause.
9. How would you handle NULL values in SQL?
NULL values can represent missing or unknown data. Hereโs how to manage them:
- Use IS NULL or IS NOT NULL in WHERE clauses to filter null values.
- Use COALESCE() or IFNULL() to replace NULL values with default ones.
Example:
SELECT name, COALESCE(age, 0) AS age
FROM employees;
10. What is the purpose of the GROUP BY clause?
The GROUP BY clause groups rows with the same values into summary rows. Itโs often used with aggregate functions like COUNT, SUM, AVG, etc.
Example:
SELECT department, COUNT(*)
FROM employees
GROUP BY department;
Available now! Telegram Research 2025 โ the year's key insights 
