Answered step by step
Verified Expert Solution
Link Copied!

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 C Coursera 55m left ALL 2 3 M Inbox  Schema There is 1 table: sale. sale_id week_of_month day of week sale hackerrank.com/test/90b34anrqqo/questions/g6nrfikel3c  Coursera M Inbox Google Drive ONITC HOSTELS APP Tn

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Statistics A Decision Making Approach

Authors: David F. Groebner, Patrick W. Shannon, Phillip C. Fry

9th Edition

013302184X, 978-0133021844

More Books

Students also viewed these Programming questions