SELECT product_name, SUM(revenue) AS total_revenue FROM sales_2024 WHERE category = 'digital' GROUP BY product_name ORDER BY total_revenue DESC LIMIT 10; +-------------------------+---------------+ | product_name | total_revenue | +-------------------------+---------------+ | Digital Marketing | 2,450,000 | | E-Commerce Platform | 1,890,000 | | SEO Services | 1,230,000 | | Social Media Ads | 980,000 | | Content Strategy | 750,000 | +-------------------------+---------------+ UPDATE campaigns SET status = 'active' WHERE start_date <= NOW() AND budget > 0; INSERT INTO analytics (date, visitors, conversions, revenue) VALUES ('2024-12-01', 15420, 387, 125000); SELECT DATE(created_at) AS date, COUNT(*) AS orders, SUM(total) AS revenue FROM orders WHERE status = 'completed' GROUP BY DATE(created_at) ORDER BY date DESC; SELECT product_name, SUM(revenue) AS total_revenue FROM sales_2024 WHERE category = 'digital' GROUP BY product_name ORDER BY total_revenue DESC LIMIT 10;