SQL: 50 Real-Time YouTube Analytics Challenges
Solve simple to advanced SQL problems using real YouTube data, just like a
Data Analyst
.
SELECT, ORDER BY, LIMIT
WHERE
3. Channels from India
Solution
Easy
4. Public Videos
Solution
Easy
5. HD Videos
Solution
Easy
6. Videos with Captions
Solution
Easy
7. Channels with Hidden Subscriber Count
Solution
Easy
8. Successfully Processed Videos
Solution
Easy
9. Embeddable Videos
Solution
Easy
10. Made for Kids Videos
Solution
Easy
GROUP BY
NULL Handling
GROUP BY, ORDER BY, LIMIT
ORDER BY, LIMIT
JOIN, ORDER BY
GROUP BY, HAVING
GROUP BY, WHERE
Date Functions
GROUP BY, Date Functions
Multi-table JOIN, GROUP BY
JOIN, Aggregation
JOIN, SUM, LIMIT
GROUP BY, HAVING, Subquery
Correlated Subquery
GROUP BY, HAVING
CTE, Window Function
CTE, ROW_NUMBER
Date Functions, GROUP BY
CTE, Aggregation
CTE, Window Function, JOIN
DATA ANALYST ROADMAP