SQL in Action: Real-World Examples for Beginners

SELECT product_name, price, total_sales, rating FROM products WHERE rating >= 4.0 ORDER BY total_sales DESC LIMIT 5;

SELECT genre, COUNT(*) as shows_watched FROM watch_history WHERE watch_date >= '2024-01-01' GROUP BY genre ORDER BY shows_watched DESC;

SELECT post_type, AVG(likes) as avg_likes, COUNT(*) as total_posts FROM posts GROUP BY post_type;