Question: SELECT quarter_number, AVG(rating) AS avg_rating FROM ( SELECT quarter_number, CASE CUSTOMER_FEEDBACK WHEN 'Very Bad' THEN 1 WHEN 'Bad' THEN 2 WHEN 'Okay' THEN 3 WHEN

SELECT quarter_number, AVG(rating) AS avg_rating FROM ( SELECT quarter_number, CASE CUSTOMER_FEEDBACK WHEN 'Very Bad' THEN 1 WHEN 'Bad' THEN 2 WHEN 'Okay' THEN 3 WHEN 'Good' THEN 4 WHEN 'Very Good' THEN 5 ELSE NULL END AS rating, quarter_number FROM order_t ) AS customer_feedback GROUP BY quarter_number ORDER BY quarter_number is this query correct

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

What is the average rating in each quarter? -- Very Bad is 1, Bad is 2, Okay is 3, Good is 4, Very Good is 5. Use a common table expression and in that CTE, assign numbers to the different customer...

Please help with this project. I am in the weeds this semester Case 2 - Toyota's Hybrid Drive Systems The main goal of this case is to reinforce your understanding of how to estimate the cost of...

Bloomberg CASEO Businessweek STUDIES 4 Weighted Average Cost of Capital Analyze how the theoretical concepts This lesson explores how several companies and industries are of weighted average cost of...

Ans??? 20 Bloomberg Businessweek Recessions The Year Ahead 2019 An early warning system for downturns may be giving off mixed signals Historically, the $15.4 trillion U.S. Treasury market has offered...

You are a data analyst working for an online bookstore. The bookstore has a table named "Books" that contains information about various books, including their titles, authors, and ratings. Your task...

3 . Create a new view that shows the same information as # 2 EXCEPT it should show the average rating of each movie. Use the view from # 2 in the FROM clause. Name the average rating column...

What are two advantages of using views? p Flag question: Question 2 Question 2 1 pts 2 . Select everything from the movies view that we created in class. Screen Shot 2 0 2 2 - 0 7 - 0 1 at 4 . 0 7 ....

Tableau Movie ratings 1 T Standard F File Data Worksheet Dashboard Story Analysis Map Format Server Window Help # Data Analytics imdb_top_1000+ (Multipl... Search Tables > imdb_top_1000 Q

Having a hard time understanding how to go about this problem New Castle County Technical Services (NCCTS) provides technical support for a number of local companies. Part of their customer service...

Please help me to do this interface and linking in Microsoft VISUAL Studio ( Window Form application ) Please use c# Figure 1 till figure 10 anything Overview of My Tutors (MyT) My Tutors is a free,...

1. An entity reports the cumulative effect on earnings of prior years as an adjustment of the beginning balance of retained earnings for the first period presented. For which of the following...

How can partnership profits and losses be divided among partners?

What are some Training and guidance for foster parent on boundary setting for their children

You have been asked to determine the amount available for the unsecured claims, calculate the cents on the dollar that the unsecured creditors are estimated to get, and calculate the estimated...