Coursera M Inbox left hackerrank.com/test/90b34anrqqo/questions/g6nrfikel3c ONITC HOSTELS APP Google Drive O 3. Question 3 Schema...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
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 ... View the full answer
Related Book For
Business Statistics A Decision Making Approach
ISBN: 9780133021844
9th Edition
Authors: David F. Groebner, Patrick W. Shannon, Phillip C. Fry
Posted Date:
Students also viewed these programming questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
- A large, open bucket of water sits on a table. The height of the water level in the bucket is 4 m above the surface of the table. A small hole is made in the bucket at a distance of 10 cm above the...
-
After reviewing the tutorials on www.internetsociety.org/your-digital-footprint-matters, do you plan to alter your online habits? Are you concerned about your digital footprint and the data trail you...
-
Study the format of the analysis of variances in Exhibit 12-12. Suppose production is 156,000 units. Also assume the following: Prepare an analysis of variances similar to that shown in Exhibit...
-
A solar electric engine operating between \(5^{\circ} \mathrm{C}\) and \(95^{\circ} \mathrm{C}\) has an efficiency equal to one-half the Carnot efficiency. This engine is to drive a \(4...
-
The following are the major balance sheet classifications: Current assets (CA).......... Current liabilities (CL) Long-term investments (LTI)....... Long-term liabilities (LTL) Property, plant, and...
-
What is the average billing daily balance and finance charge (APR 15%) for the revolving credit account (assume a 30 day billing cycle)? Please fill out the table attached. Billing Date Previous...
-
(a) What payment should Maria make on the account? (b) How should she notify her credit card issuer about the unauthorized use? (c) Once the matter is resolved, what should Maria do to ensure that...
-
1. Research the motivations for Sarbanes-Oxley Act of 2002. In one paragraph each, identify two different companies whose actions created this motivation. Describe or list in detail the specific acts...
-
Show the manual calculation to find V LOAD using nodal analysis, mesh analysis, superposition, source transformation, and Thevenin or Norton theorem by using the value from group no. 3 on Table 2. ...
-
Required : a) Explain why cheque # 55713 was posted a second time in the bank statement, this time with the term 'Refer to Drawer' b) What does the transaction called Credit Transfer as shown in the...
-
The following cost data relate to the manufacturing activities of Chang Company during the just completed year: Manufacturing overhead costs incurred: Indirect materials Indirect labor. Property...
-
The accounting records of Wall's China Shop reflected the following balances as of January 1, Year 2: Cash Beginning inventory Common stock Retained earnings The following five transactions occurred...
-
Calculate the beginning balance, monthly payment, interest, principal reduction, and ending balance for 30 year mortgage and 15 year mortgage using the first table. I need the formulas. please...
-
1.suppose that E and F are independent events, P(E) = 0.7 and P(F) = 0.1. Find P(E or F). answer: 2.You roll a die 9 times. What is the probability of rolling at least one 6? Round your answer to 3...
-
1. True or False. Pitfalls to consider in a statistical test include nonrandom samples, small sample size, and lack of causal links. 2. Because 25 percent of the students in my morning statistics...
-
Quite a few years ago, a popular show called Lets Make a Deal appeared on network television. Contestants were selected from the audience. Each contestant would bring some silly item that he or she...
-
Given the following discrete probability distribution, x P (x) 500.375 650.15 700.225 750.05 900.20 a. Calculate the expected value of x. b. Calculate the variance of x. c. Calculate the standard...
-
Test the significance of the regression model at Step 1 of the process. Justify the significance level you have selected. The J. J. McCracken Company has authorized its marketing research department...
-
The rotor shown in Fig. 9.44 (a) is balanced temporarily in a balancing machine by adding the masses \(m_{1}=m_{2}=90 \mathrm{~g}\) in the plane \(A\) and \(m_{3}=m_{4}=90 \mathrm{~g}\) in the plane...
-
A turbine rotor is run at the natural frequency of the system. A stroboscope indicates that the maximum displacement of the rotor occurs at an angle \(229^{\circ}\) in the direction of rotation. At...
-
The cylinders of a four-cylinder in-line engine are placed at intervals of \(300 \mathrm{~mm}\) in the axial direction. The cranks have the same length, \(100 \mathrm{~mm}\), and their angular...
Study smarter with the SolutionInn App