Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

/* [Q3] Are customers getting more dissatisfied over time? Hint: Need the percentage of different types of customer feedback in each quarter. Use a common

/* [Q3] Are customers getting more dissatisfied over time?
Hint: Need the percentage of different types of customer feedback in each quarter. Use a common table expression and
determine the number of customer feedback in each category as well as the total number of customer feedback in each quarter.
Now use that common table expression to find out the percentage of different types of customer feedback in each quarter.
Eg: (total number of very good feedback/total customer feedback)* 100 gives you the percentage of very good feedback.
i need sql query for this statement
image text in transcribed
New wheels Data Dictionary shipper_id: Unique ID of the Shipper shipper_name: Name of the shipper shipper_contact_detai1s: Contact detai1 of the shipper product_id: Unique ID of the Product vehicle_maker: vehicle Manufacturing company name vehicle_mode 1: Vehicle model name vehicle_color: color of the vehicle vehicle_mode1_year: Year of Manufacturing vehicle_price: Price of the vehicle quantity: ordered Quantity customer_id: Unique ID of the customer customer_name: Name of the customer gender: Gender of the customer job_title: Job Title of the customer phone_number: Contact detai1 of the customer emai1_address: Email address of the customer city: Residing city of the customer country: Residing country of the customer state: Residing state of the customer customer_address: Address of the customer order_date: Date on which customer ordered the vehicle order_id: Unique ID of the order ship_date: Shipment Date ship-mode: Shipping Mode/class shipping: shipping ways posta1_code: Postan code of the customer discount: Discount given to the customer for the particular order by credit card in percentage credit_card_type: credit Card Type credit card number: Credit card number customer_feedback: Feedback of the customer quarter_number : Quarter Number

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

Students also viewed these Databases questions

Question

Understand the roles of signs, symbols, and artifacts.

Answered: 1 week ago

Question

Discuss the key ambient conditions and their effects on customers.

Answered: 1 week ago

Question

Be familiar with the integrative servicescape model.

Answered: 1 week ago