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...
-
Create a Web page named magic.html that simulates the functionality of a Magic 8 Ball. Your page should look similar to the one in Figure 9.10, with a text box for entering a yes-or-no question, and...
-
1. What is the term for the right of Roche citizens to walk across Shoepkes land on the trail? 2. What covenants would most courts infer were included in the warranty deed that was used in the...
-
The steel bar \(A B\) has a rectangular cross section. If it is pin connected at its ends, determine the maximum allowable intensity \(w\) of the distributed load that can be applied to \(B C\)...
-
Dry air is bubbled through 25.0 liters of water at a rate of 15.0 liters (STP)/min. The air leaving the liquid is saturated with water at 25C and 1.5 atm. How long will it take for all of the water...
-
Ameer invested $ 926 in a bank account that earns 12.98 percent per year. How much will Ameer receive after 14.12 years of maintaining the investment the account? Do NOT include $ in your answer....
-
Use the following payoff table for Hardaway Corporation and Paxton Industries. These two firms must make simultaneous pricing decisions. They can choose low, medium, or high prices. The payoffs given...
-
A chemical engineering plant needs to produce a solution that is 25% salt by weight. The plant currently has 1000 kg of a 15% salt solution and wants to add water to dilute the solution to a 25% salt...
-
In a tropical region, rainforest destruction is taking a toll. Assuming the economic standards of local residents were to improve through this activity, would this lead to the tropical rainforests...
-
In what circumstances would an organization use strategic communication to deal with non-market issues?
-
Why does strategic communication need to deal with external issues in the mid- and long-term horizons?
-
Do I understand the framework used to write a strategic communication plan?
-
Did you ever participate in the development or implementation of a health communication intervention? If yes, what were some of the key learnings and how do they relate to the attributes of health...
-
What is the present value of the cash flow given below, interest at 8% compounded semi-annually. 0 Oa.$3.333 Ob.$4.375 O c. $5.383 O d.$6,307 0.5 1 1.5 . 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 $500...
-
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...
-
You are the senior partner of a large, local audit firm. In reviewing the work of a junior staff member on a compilation engagement for Greasemonkey's Delight Inc., a local autoparts store (in which...
-
The chapter discussed three issues to consider when obtaining evidence using a sample-based audit procedure: a. The number of transactions or items to examine b. The actual transactions or items to...
-
Compare and contrast statistical and non-statistical (judgmental) sampling. Include in your discussion conditions that might make one approach to sampling more desirable than the other.
Study smarter with the SolutionInn App