Files

Basics
CASE-WHEN
Join
OFFSET-FETCH
PIVOT-UNPIVOT
Questions_by_ID
- 1045_Customers_Who_Bought_All_Products.sql
- 1050_Actors_and_Directors_Who_Cooperated_At_Least_Three_Times.sql
- 1068_Product_Sales_Analysis_I.sql
- 1069_Product_Sales_Analysis_II.sql
- 1070_Product_Sales_Analysis_III.sql
- 1075_Project_Employees_I.sql
- 1076_Project_Employees_II.sql
- 1077_Project_Employees_III.sql
- 1082_Sales_Analysis_I.sql
- 1083_Sales_Analysis_II.sql
- 1084_Sales_Analysis_III.sql
- 1097_Game_Play_Analysis_V.sql
- 1098_Unpopular_Books.sql
- 1107_New_Users_Daily_Count.sql
- 1112_Highest_Grade_For_Each_Student.sql
- 1113_Reported_Posts.sql
- 1126_Active_Businesses.sql
- 1127_User_Purchase_Platform.sql
- 1132_Reported_Posts_II.sql
- 1141_User_Activity_for_the_Past_30_Days_I.sql
- 1142_User_Activity_for_the_Past_30_Days_II.sql
- 1148_Article_Views_I.sql
- 1149_Article_Views_II.sql
- 1158_Market_Analysis_I.sql
- 1159_Market_Analysis_II.sql
- 1164_Product_Price_at_a_Given_Date.sql
- 1173_Immediate_Food_Delivery_I.sql
- 1174_Immediate_Food_Delivery_II.sql
- 1179_Reformat_Department_Table.sql
- 1193_Monthly_Transactions_I.sql
- 1194_Tournament_Winners.sql
- 1204_Last_Person_to_Fit_in_the_Elevator.sql
- 1205_Monthly_Transactions_II.sql
- 1211_Queries_Quality_and_Percentage.sql
- 1212_Team_Scores_in_Football_Tournament.sql
- 1225_Report_Contiguous_Dates.sql
- 1241_Number_of_Comments_per_Post.sql
- 1251_Average_Selling_Price.sql
- 1264_Page_Recommendations.sql
- 1270_All_People_Report_to_the_Given_Manager.sql
- 1280_Students_and_Examinations.sql
- 1285_Find_the_Start_and_End_Number_of_Continuous_Ranges.sql
- 1294_Weather_Type_in_Each_Country.sql
- 1303_Find_the_Team_Size.sql
- 1308_Running_Total_for_Different_Genders.sql
- 1321_Restaurant_Growth.sql
- 1322_Ads_Performance.sql
- 1327_List_the_Products_Ordered_in_a_Period.sql
- 1336_Number_of_Transactions_per_Visit.sql
- 1341_Movie_Rating.sql
- 1350_Students_With_Invalid_Departments.sql
- 1355_Activity_Participants.sql
- 1364_Number_of_Trusted_Contacts_of_a_Customer.sql
- 1369_Get_the_Second_Most_Recent_Activity.sql
- 1378_Replace_Employee_ID_With_The_Unique_Identifier.sql
- 1384_Total_Sales_Amount_by_Year.sql
- 1393_Capital_Gain_Loss.sql
- 1398_Customers_Who_Bought_Products_A_and_B_but_Not_C.sql
- 1407_Top_Travellers.sql
- 1412_Find_The_Quiet_Students_in_All_Exams.sql
- 175_Combine_Two_Tables.sql
- 176_Second_Highest_Salary.sql
- 177_Nth_Highest_Salary.sql
- 178_Rank_Scores.sql
- 180_Consecutive_Numbers.sql
- 181_Employees_Earning_More_Than_Their_Managers.sql
- 182_Duplicate_Emails.sql
- 183_Customers_Who_Never_Order.sql
- 184_Department_Highest_Salary.sql
- 185_Department_Top_Three_Salaries.sql
- 196_Delete_Duplicate_Emails.sql
- 197_Rising_Temperature.sql
- 262_Trips_and_Users.sql
- 511_Game_Play_Analysis_I.sql
- 512_Game_Play_Analysis_II.sql
- 534_Game_Play_Analysis_III.sql
- 550_Game_Play_Analysis_IV.sql
- 569_Median_Employee_Salary.sql
- 570_Managers_with_at_Least_5_Direct_Reports.sql
- 571_Find_Median_Given_Frequency_of_Numbers.sql
- 574_Winning_Candidate.sql
- 577_Employee_Bonus.sql
- 578_Get_Highest_Answer_Rate_Question.sql
- 579_Find_Cumulative_Salary_of_an_Employee.sql
- 580_Count_Student_Number_in_Departments.sql
- 584_Find_Customer_Referee.sql
- 585_Investments_in_2016.sql
- 586_Customer_Placing_the_Largest_Number_of_Orders.sql
- 595_Big_Countries.sql
- 596_Classes_More_Than_5_Students.sql
- 597_Friend_Requests_I_Overall_Acceptance_Rate.sql
- 601_Human_Traffic_of_Stadium.sql
- 602_Friend_Requests_II_Who_Has_the_Most_Friends.sql
- 603_Consecutive_Available_Seats.sql
- 607_Sales_Person.sql
- 608_Tree_Node.sql
- 610_Triangle_Judgement.sql
- 612_Shortest_Distance_in_a_Plane.sql
- 613_Shortest_Distance_in_a_Line.sql
- 614_Second_Degree_Follower.sql
- 615_Average_Salary_Departments_VS_Company.sql
- 618_Students_Report_By_Geography.sql
- 619_Biggest_Single_Number.sql
- 620_Not_Boring_Movies.sql
- 626_Exchange_Seats.sql
- 627_Swap_Salary.sql
SQL-Command
Subquery
Variable
Window-Function
Readme.md

1069_Product_Sales_Analysis_II.sql

Create 1069_Product_Sales_Analysis_II.sql

Mar 29, 2020

4fef6ac · Mar 29, 2020