Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Coursera M Inbox left hackerrank.com/test/90b34anrqqo/questions/g6nrfikel3c ONITC HOSTELS APP Google Drive O 3. Question 3 Schema T NITC Eduserver Sample Data Tables Google Scholar NITC-IMS
Coursera M Inbox left hackerrank.com/test/90b34anrqqo/questions/g6nrfikel3c ONITC HOSTELS APP Google Drive O 3. Question 3 Schema T NITC Eduserver Sample Data Tables Google Scholar NITC-IMS Given a table with sales for one month, fetch the days of the week for every week of the month on which the total sales the maximum number of super sales are made. A super sale is a sale that is more than 5% on a particular date. If more than one day in a week had that number of super sales, return them as a comma-delimited list, ordered ascending. OneDrive T Torrent C Coursera 55m left ALL 2 3 M Inbox Schema There is 1 table: sale. sale_id week of month day of week sale amount 407 725 550 364 Sample Data Tables 817 sale_id week_of_month 721 3 868 379 Name: 518 625 522 F2 3 3 3 3 3 3 3 3 Type 3 int 3 int int F3 int The amount of sale. Unique id of the sale. Week of the month in which the sale was made. Day of the week on which the sale was made. sale sale day_of_week 1 1 1 1 1 1 1 2 2 2 Description 2 F4 $ sale_amount 2830 2460 5120 2990 5240 1320 4230 5800 3830 5320 1650 F5 % F6 F7 EX & FE hackerrank.com/test/90b34anrqqo/questions/g6nrfikel3c Coursera M Inbox Google Drive ONITC HOSTELS APP Tn NITC Eduserver 55m left ALL () O 1 2 3 314 463 845 612 606 741 week_of_month 3 3 3 3 3 3 3 week_of_month day of week 3 4,7 3 3 3 O 3 3 OUTPUT 3 Explanation day_of_week 1 2 3 4 5 6 7 6 7 7 7 7 7 3 3 2 4 2 count_of_super_sales 3 4640 4 1980 2040 2020 4510 1640 Google Scholar For the 3rd week, days 4 and 7 had the maximum number of super sales.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
In the images you provided youre being asked to solve a SQL problem where the task is to find the days of the week for every week of a month that had ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started