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',

![enum(Food', Bus', Recharge','Cabs") [ Means category] Order_date Company_id enum('Ola','Uber,'Ezpay',"Redbus','Swiggy', Zomato") Customer_id Order_value](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678731d11295_8206678731ce6b16.jpg)
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
Get step-by-step solutions from verified subject matter experts
