Question: Task 3: 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',

 Task 3: 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

Task 3: 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 ? Q3. Get average order_value for the month of March 2018 for all successful orders for each category? Task 4: Write steps or queries Consider these tables: > Orders (order_id,category_id,customer_id, order_date, order_value, discount) > Customer (customer_id, customer_name,mobile,email) > Categories (category_id, category_name, desc) Write all the steps to create an aggregated table with the following fields: > Table 1 (A flat table which contains the following information)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!