A small e-commerce firm captures revenue info. The table revenue has the following description: Type Column...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A small e-commerce firm captures revenue info. The table revenue has the following description: Type Column date field date country varchar(3) category varchar(30) revenue float buyers int Write a query to find the top 3 categories by revenue per buyer, along with the values. The output should be sorted in descending order for revenue per buyer and ascendinng order for category 4 Note: Use round(x, 3) to round up your values to 3 decimal places. For e.g: round (3/5,3) = 0.600 Note: Build a query string with only one statement (semicolon optional). Multiple statements (separated by semicolon) in the query string are not allowed. Sample Input Revenue date_field country category revenue buyers 2016-06-21 US Electronics 400 15 2016-06-21 US Apparel 250 2016-06-21 US Furniture 1100 6 2016-06-21 CA Stationery 100 2016-06-21 CA Electronics 150 11 25 22 42 Sample Output category- revenue_per_buyers Furniture 183.333 Apparel Electronics 14.865 22.727 A small e-commerce firm captures revenue info. The table revenue has the following description: Type Column date field date country varchar(3) category varchar(30) revenue float buyers int Write a query to find the top 3 categories by revenue per buyer, along with the values. The output should be sorted in descending order for revenue per buyer and ascendinng order for category 4 Note: Use round(x, 3) to round up your values to 3 decimal places. For e.g: round (3/5,3) = 0.600 Note: Build a query string with only one statement (semicolon optional). Multiple statements (separated by semicolon) in the query string are not allowed. Sample Input Revenue date_field country category revenue buyers 2016-06-21 US Electronics 400 15 2016-06-21 US Apparel 250 2016-06-21 US Furniture 1100 6 2016-06-21 CA Stationery 100 2016-06-21 CA Electronics 150 11 25 22 42 Sample Output category- revenue_per_buyers Furniture 183.333 Apparel Electronics 14.865 22.727 A small e-commerce firm captures revenue info. The table revenue has the following description: Type Column date field date country varchar(3) category varchar(30) revenue float buyers int Write a query to find the top 3 categories by revenue per buyer, along with the values. The output should be sorted in descending order for revenue per buyer and ascendinng order for category 4 Note: Use round(x, 3) to round up your values to 3 decimal places. For e.g: round (3/5,3) = 0.600 Note: Build a query string with only one statement (semicolon optional). Multiple statements (separated by semicolon) in the query string are not allowed. Sample Input Revenue date_field country category revenue buyers 2016-06-21 US Electronics 400 15 2016-06-21 US Apparel 250 2016-06-21 US Furniture 1100 6 2016-06-21 CA Stationery 100 2016-06-21 CA Electronics 150 11 25 22 42 Sample Output category- revenue_per_buyers Furniture 183.333 Apparel Electronics 14.865 22.727 A small e-commerce firm captures revenue info. The table revenue has the following description: Type Column date field date country varchar(3) category varchar(30) revenue float buyers int Write a query to find the top 3 categories by revenue per buyer, along with the values. The output should be sorted in descending order for revenue per buyer and ascendinng order for category 4 Note: Use round(x, 3) to round up your values to 3 decimal places. For e.g: round (3/5,3) = 0.600 Note: Build a query string with only one statement (semicolon optional). Multiple statements (separated by semicolon) in the query string are not allowed. Sample Input Revenue date_field country category revenue buyers 2016-06-21 US Electronics 400 15 2016-06-21 US Apparel 250 2016-06-21 US Furniture 1100 6 2016-06-21 CA Stationery 100 2016-06-21 CA Electronics 150 11 25 22 42 Sample Output category- revenue_per_buyers Furniture 183.333 Apparel Electronics 14.865 22.727 A small e-commerce firm captures revenue info. The table revenue has the following description: Type Column date field date country varchar(3) category varchar(30) revenue float buyers int Write a query to find the top 3 categories by revenue per buyer, along with the values. The output should be sorted in descending order for revenue per buyer and ascendinng order for category 4 Note: Use round(x, 3) to round up your values to 3 decimal places. For e.g: round (3/5,3) = 0.600 Note: Build a query string with only one statement (semicolon optional). Multiple statements (separated by semicolon) in the query string are not allowed. Sample Input Revenue date_field country category revenue buyers 2016-06-21 US Electronics 400 15 2016-06-21 US Apparel 250 2016-06-21 US Furniture 1100 6 2016-06-21 CA Stationery 100 2016-06-21 CA Electronics 150 11 25 22 42 Sample Output category- revenue_per_buyers Furniture 183.333 Apparel Electronics 14.865 22.727 A small e-commerce firm captures revenue info. The table revenue has the following description: Type Column date field date country varchar(3) category varchar(30) revenue float buyers int Write a query to find the top 3 categories by revenue per buyer, along with the values. The output should be sorted in descending order for revenue per buyer and ascendinng order for category 4 Note: Use round(x, 3) to round up your values to 3 decimal places. For e.g: round (3/5,3) = 0.600 Note: Build a query string with only one statement (semicolon optional). Multiple statements (separated by semicolon) in the query string are not allowed. Sample Input Revenue date_field country category revenue buyers 2016-06-21 US Electronics 400 15 2016-06-21 US Apparel 250 2016-06-21 US Furniture 1100 6 2016-06-21 CA Stationery 100 2016-06-21 CA Electronics 150 11 25 22 42 Sample Output category- revenue_per_buyers Furniture 183.333 Apparel Electronics 14.865 22.727
Expert Answer:
Answer rating: 100% (QA)
You can use the following SQL query to find the top 3 categories by revenue per buyer SELECT cate... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
How can organizations proactively address the ethical and moral dilemmas inherent in the pursuit of organizational development initiatives, balancing the imperative for growth and profitability with...
-
Provide a detailed marketing plan for International Delight coffee creamers.
-
Superior Markets, Incorporated, operates three stores in a large metropolitan area. A segmented absorption costing income statement for the company for the last quarter is given below: Superior...
-
MAX DIVISOR TREE Let a tree exists with the root value N. The property of this tree is that each of its nodes branches out to the nodes with a value equal to one of its divisors (except 1 and the...
-
Given the strains: xx = 2,000 yy = 3,000 zz = 4,500 xy = 200 yz = 300 zx = 225 Where x = east, y = north, z = up, compression is positive, the units are micro inches per inch, Youngs modulus E =...
-
Determine the force in members GJ and IK of the truss shown. 5 kNA 11m 5 kN 5 kN b 3 m 2 m 2 m
-
A safety PLC has an Ethernet connection port used to send information to a data server in the system. Can this port be used without a cybersecurity risk?
-
The following payroll liability accounts are included in the ledger of Grandon Company on January 1, 2014. FICA Taxes Payable .............$ 540 Federal Income Taxes Payable ......... 1,100 State...
-
Q1. Jassim Compagny is producing only one product. Two types of direct materials are used to produce this product: direct material type( A) and direct material type B. The estimated data for Jassim...
-
1. The following information is available for the Albert and Allison Gaytor family in addition to that provided in Chapters 16. The Gaytors paid tuition and fees for both Crocker and Cayman to attend...
-
Feet for Athletes, Incorporated sells athletic shoes and socks. Shoes sell for $135 per unit and have a variable cost of $60 per unit. Socks sell for $25 a bag with a variable cost of $10 per bag....
-
Crane Corporation began operations in 2025. During the year, the company earned sales revenues of $1686800 with related cost of goods sold of $858600. The company incurred administrative expenses of...
-
Kristen is leading a sales meeting that has become unproductive. Her team members are way off topic and everyone is talking at once. There seems to be a lack of structure to the meeting as a whole....
-
You are the manager of the small Westbrook In- Patient Dialysis Treatment Facility. When you arrived in your office today, you were informed that a patient and the patient's family need to see you...
-
Information on the asset accounts of Entity A as of December 31, 20x1 is as follows: Cash Accounts receivable Notes receivable (trade) Notes receivable (nontrade) - P40,000 due within 1 yr. insurance...
-
Identify articulately diversity and inclusion in an unassisted environment without relying on reference materials Is this statement include condition, performance, and criteria?
-
Now draw the reflected segments of the three special rays considered previously. Use the label Rayl, for the reflected segment of Ray 1, Ray2, for the reflected segment of Ray 2, and so forth. Make...
-
The Ranch 888 Noodle Company sells two types of dried noodles:ramen, at $6.50 per box, and chow fun, at $7.70 per box. So farthis year, the company has sold a total of 110,096 boxes ofnoodles,...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-7. Ivan sold the following securities during the year and received a Form 1099-B that...
-
During 2012, William purchases the following capital assets for use in his catering business: New passenger automobile (September 30)........................$21,500 Baking equipment (June 30)...
-
Jason and Mary are married taxpayers in 2012. They are both under age 65 and in good health. For this tax year, they have a total of $41,000 in wages and $500 in interest income. Jason and Mary's...
-
Describe what sexual harassment is and what forms it can take.
-
Explain public policies that protect employees from unlawful discharge.
-
Discuss under what conditions unemployment compensation can be denied to a claimant.
Study smarter with the SolutionInn App