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

-- 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 Programming Questions!

Q:

Beststyle is a leading clothing brand with multiple retail stores across India. Their outlets are well spread in tier 1 and 2 cities of India. Moreover, within the tier 1 cities, they have maintained...

Q:

BERKSHIRE TEAM Portfolio Performance Report for the period ending 14/06/2020 PERFORMANCE Note: Some data and information in this Report has been removed for exam purposes Mod Duration at Start Of...

Q:

Sterling properties an German company whose shares are traded on the German Stock Exchange. The company was established in the late nineties when a major German insurance company moved its portfolio...

Q:

MYSQL 1. Suppose you have a database modeling a mobile riding platform somewhat similar to Uber, which is given by the following schema: PASSENGER (pid, pname, city, phone) DRIVER (did, dname, city,...

Q:

Note: You can work on the SQL Server to write the below questions SQL Query. 1. Suppose you have a database modeling a mobile riding platform somewhat similar to Uber, which is given by the following...

Q:

Question 4 - PHP (20 Marks) The scenario given below shows how a user can write comments and give ratings on the hotels that they have stayed in. Table : Hotel Hotel ID Hotel_Name Hotel Star H1 Hotel...

Q:

Question 3 (20 marks) ? Lectures 5 and 6: Net present value and other investment criteria and Capital Budgeting You are evaluating a proposal to buy a new machine. The base price is $108,000, and...

Q:

Question 4- PHP (20 Marks) The scenario given below shows how a user can write comments and give ratings on the hotels that they have stayed in. Table: Hotel Hotel ID Hotel Name Hotel Star H1 Hotel...

Q:

the table structures and columns name should be implemented in the coding and its is one question with some sub parts so tell me about the chegg policy and stuff. All the information is given in the...

Q:

ASSIGNMENT: BBA/BCOM - MANAGEMENT ACCOUNTING (MAIN) QUESTION 1 1.1 1.2 INTAKE (20 Marks) REQUIRED Calculate the hourly recovery tariff for K. Ntuli from the information provided below. INFORMATION (4...

Q:

Let L be a partially ordered set in which every subset has a least upper bound. Suppose that L has a bottom element. Prove that L is a complete lattice

Q:

Staples, Inc., operates a chain of office supply stores throughout the United States. For 2004 and 2003, Staples reported (in thousands) the following operating data: a. Compute the percent of gross...

Q:

conduct a general PESTEL Analysis for General Motors and Ford. Refelct on any general factos that might be different between these two firms

Q:

Putting the coffee into Europe By Rebecca Wright in London Over a cup of steaming Ethiopian blend Mark Mckeon, president of Starbucks Europe, says: "It's what we call a BHAG. That's a Big Hairy...