2. Top 3 movie categories by sales

easy

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

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.

Last Submission postgres

Expected results



More SELECT, WHERE, AND, OR, ORDER BY, LIMIT questions

ID Title Level FTPR
228 Analyzing Sequential Purchase Behavior microsoft hard -
227 Aggregate Sale Amounts per Customer microsoft hard -
226 Customer Lifetime Value (CLV) and Segmentation microsoft hard -
225 Customer Behavior Analysis microsoft hard -
224 Categories with High Average Product Price microsoft medium -
223 Cumulative Total Sales by Day microsoft hard -
222 Product Sales Ranking Within Categories microsoft hard -
221 Customers With More Than 5 Products in a Single Transaction microsoft hard -
220 Most Expensive Product in Each Category microsoft hard -
219 Inactive Customers in the New Year of 2024 microsoft medium -
218 Total Amount Spent by Each Customer microsoft medium -
217 Most engaged customers roblox hard
10%
210 Issuer and merchant report visa easy
100%
200 Last week's absent students snap medium
67%
175 Employees' email account amazon easy
14%
152 Salary analysis dropbox easy
20%
126 Top 3 restaurants uber hard
10%
111 Second most popular product amazon medium
16%
92 Acceptance rate first week of 2021 spotify easy
14%
17 GROUCHO WILLIAMS’ actor_id easy
57%
16 Staff who live in Woodridge easy
65%
4 Staff without a profile image easy
66%
3 Top 5 shortest movies easy
49%
1 Top store for movie sales easy
24%