Question: write a script in MySQL ?? 1] Are customers getting more dissatisfied over time? Need the percentage of different types of customer feedback in each

1] Are customers getting more dissatisfied over time? Need the percentage of different types of customer feedback in each quarter. Use a cammon tabie expre determine the number of customer feedback in each category as well as the total number of custoner fe Now use that common table expression to find out the percentage of different types of custoser freabs Eg: (total number of very good feedback/total customer feedback) 100 gives you the percentagn of ver. shipper_id: Unique ID of the Shipper shipper_name: Name of the Shipper shipper_contact_details: Contact detail of the shipper product_id: Unique ID of the Product vehicle_maker: Vehicle Manufacturing company nane vehicle_model: Vehicle model nane vehicle_color: Color of the Vehicle vehicle_model year; Year of Manufacturing vehicle_price: Price of the Vehicle quantity: Ordered quantity customer_id: Unique ID of the customer customer_nase: Name of the customer gender: Gender of the customer Job_title: Job Title of the customer phone number: contact detail of the custoner emai1_address: Email address of the custoner city: Residing city of the custoner country: flesiding country of the customer state: Residing state of the custoner customer_address: Address of the customer order_date: Date on which customer ordered the vehicle order-id: Unique. ID of the onder ship_date: Shipment Date ship_mode: Shipping Mode/Class shipping: Shipping ways postal_code: Postal Code of the custoner discount: Discount given to the custoner for the particular or credit_card_type: Credit Card Type
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
