Instruction
- Write a query to find the top 3 film categories that generated the most sales.
- The order of your results doesn't matter.
Table: sales_by_film_category
Total sales by movie categories.
col_name | col_type -------------+---------- category | text total_sales | numeric
Sample results
category ----------- Category 1 Category 2 Category 3
Expected results
Solution postgres
SELECT category
FROM sales_by_film_category
ORDER BY total_sales DESC
LIMIT 3;
Explanation
This query selects the "category" column from the "sales_by_film_category" table, which presumably contains data on the sales of films in different categories. The results are then sorted in descending order based on the "total_sales" column, which likely contains the total revenue generated by each category. Finally, the query limits the output to the top three categories with the highest total sales. This can be useful for identifying the most profitable film categories and making business decisions based on that information.
Copied
Your results