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?

Answer rating: 100% (QA)

Consider the table structure Orders Orderid pk Ordertype enumFoodBusRechargeCabs Means category Orde... View the full answer