Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Retail Management A Strategic Approach

Authors: Barry Berman, Joel Evans, Patrali Chatterjee

13th Edition

0133796841, 9780133796841

More Books

Students also viewed these General Management questions

Question

Demonstrate knowledge of the company/organization and the position.

Answered: 1 week ago

Question

Show P(AB) = P(A)P(B) if A and B are independent

Answered: 1 week ago

Question

2. How do I perform this role?

Answered: 1 week ago