Question: Question 4: -- Find the overall average rating given by the customers. What is the average rating in each quarter? [5 marks] -- Consider the

Question 4: -- Find the overall average rating given by the customers. What is the average rating in each quarter? [5 marks] -- Consider the following mapping for ratings: -- "Very Bad": 1, "Bad": 2, "Okay": 3, "Good": 4, "Very Good": 5 -- Hint: Use subquery and assign numerical values to feedback categories using a CASE statement. -- Then, calculate the average feedback count per quarter. Use a subquery to convert feedback -- into numerical values and group by quarter_number to compute the average.

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!

Uhe the following calendar year infomation prepore Adam Compy's atement of ca nows using the direct methed Cash paid to pchase mhinery Cash paid for merchandese inventory Cash paid for operating...

Tracy Jones has set up a business and trades as an unincorporated entity or sole trader. Tracy introduced her own car to the business. The car was worth 14,000. What journal entries should be used to...

Given 2 8 g ( x ) d x = 4 . 1 and 2 4 g ( x ) d x = 5 . 6 , determine 4 8 g ( x ) d x . Your answer should have one decimal. Be careful about signs in your calculation!

Write an essay considering whether the recent acts involving nationalization in Venezuela and Bolivia are in conformity with recognized international standards. You may compare these acts with the...