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
Fantastic news! We've Found the answer you've been seeking!
Question:
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?
Related Book For
Concepts Of Database Management
ISBN: 9780357422083
10th Edition
Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt
Posted Date: