Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the trend of revenue and orders by quarters? Hint: Find out the sum of revenue and count the number of orders for each

What is the trend of revenue and orders by quarters?
Hint: Find out the sum of revenue and count the number of orders for each quarter.*/
i need proper sql code
image text in transcribed
New Wheels Data Dictionary 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 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 detail 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: Postal 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

Object Oriented Databases Prentice Hall International Series In Computer Science

Authors: John G. Hughes

1st Edition

0136298745, 978-0136298748

Students also viewed these Databases questions