Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the table structure : Orders Order_id pk Order_type enum(Food,Bus,Recharge,Cabs) [ Means category] Order_date Company_id enum(Ola,Uber,Ezpay,Redbus,Swiggy,Zomato) Customer_id Order_value Order_status enum(Pending,Cancelled,Success,Wait On Merchant) Discount Q1. Get

Consider the table structure :


Orders
Order_id pk
Order_type enum(‘Food’,’Bus’,’Recharge’,’Cabs’) [ Means category]
Order_date

Company_id enum(‘Ola’,’Uber’,’Ezpay’,’Redbus’,’Swiggy’,’Zomato’)
Customer_id
Order_value
Order_status enum(‘Pending’,’Cancelled’,’Success’,’Wait On Merchant’)
Discount

Q1. Get total orders and total order value per day for the month of March 2018 ? 

Q2. Get Total orders, order value per day for the month of March 2018 for each order type ? 

. Get average order value for the month of March 2018 for all successful orders for each category?


Step by Step Solution

There are 3 Steps involved in it

Step: 1

Consider the table structure Orders Orderid pk Ordertype enumFoodBusRechargeCabs Means category Orde... 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

Concepts Of Database Management

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

10th Edition

0357422082, 978-0357422083

More Books

Students also viewed these Finance questions

Question

What default command appears in the SQL query window?

Answered: 1 week ago