222. Product Sales Ranking Within Categories

hard microsoft

*************************************************************************************************************************************
*********************************************************************************

Table 1: msft_products

*****************************************************************************


*************************************************************************

Table 2: msft_sales

**************************************************************************************************************************************************


*******************************************************************************

Last Submission postgres

Expected results


More Microsoft questions

ID Title Level FTPR
218 Total Amount Spent by Each Customer microsoft medium -
219 Inactive Customers in the New Year of 2024 microsoft medium -
220 Most Expensive Product in Each Category microsoft hard -
221 Customers With More Than 5 Products in a Single Transaction microsoft hard -
223 Cumulative Total Sales by Day microsoft hard -
224 Categories with High Average Product Price microsoft medium -
225 Customer Behavior Analysis microsoft hard -
226 Customer Lifetime Value (CLV) and Segmentation microsoft hard -
227 Aggregate Sale Amounts per Customer microsoft hard -
228 Analyzing Sequential Purchase Behavior microsoft hard -
229 Time Between Repeat Purchases microsoft hard -
230 Customer Purchase Trend Analysis microsoft easy -