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
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Concepts Of Database Management
Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt
10th Edition
0357422082, 978-0357422083
Students also viewed these Finance questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App