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

1 Expert Approved Answer

Step: 1 Unlock

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

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 Finance Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

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")...

In the warehouse of the company Tumany Amines, Iilc., two unidentified compounds have been found. The president of the company, Wotta Stench, has hired you to identify them from their spectra:...

Think of a brand that you like. Create a mission for www.eyeem.coms Creatives.

In each of the following cases, identify the value of c so that the function f is a probability density (f vanishes outside the range of values indicated below). (i) f(x)=3c 1, - (ii) f(x) = c(1-x),...

Resolve Problem 4.19 with Î± = .1 and Î² = .8. Using MSE, determine which smoothing constants provide a better forecast. In Problem 4.19, Income at the law firm Smith and...

A loan is offered with monthly payments and a 8 . 5 0 percent APR. What s the loan s effective annual rate ( EAR ) ?

Consider the cylindrical shaped absorbent material designed to selectively remove solute A from solution. The uptake of solute A through the homogeneous absorbent material is limited by the molecular...

An n-alkane of molecular formula C28H58 has been isolated from a certain fossil plant. Write a condensed structural formula for this alkane.

Calculate the rms value of the waveform shown in Fig P 9.39 vt) (V) t

Does the following integral converge or diverge? If it converges, to what value? 0 1 3 l n ( x ) x 2 d x

Ruby offered to sell her car to John for $5000. She sent the offer by email. John sent a return email to tell Ruby he was "ok with the price" but wanted the car "cleaned and detailed if he was going...

You have been employed as a consultant to Golf R Us, Inc. The company has been having problems with account receivables and they want to use various dunning methods to better their receivables. But...

Mike decides to have a clearance sale on all the computers in stock. His plan is to sell all the inventory, making no profit and he needs to define the sale price for each computer. Each computer was...

You are working as an analyst for a large cable company that offers bundles of channels all across the United States. One of the bundles is the "basic package," which includes network channels along...

Q1. At a production level of 5,000 units, the budgeted product cost per unit is: Direct materials $30 Direct labour $10 Fixed factory overhead $6 Variable factory overhead $4 Total $50 Required:...

When a company analyzes online cart abandonment rates, it is using: Question 5 options: Psychographic segmentation Demographic segmentation Behavioral segmentation Geographic segmentation

What default command appears in the SQL query window?

Which of the following is not a type of data modification anomaly? a. Entry b. Update c. Deletion d. Insertion

Open the TaskMasterList table in Datasheet View. What field contains redundant data that most likely could be pulled into a lookup table? a. Per b. Description c. TaskID d. CategoryID or Per

What is the remaining time until the maturity date of a $10,000 strip bond if it is purchased for $4011.33 to yield 6.4% compounded semiannually until maturity?

The amount owed on a promissory note for $950 after two years and five months is $1165.79. What monthly compounded nominal rate of interest was charged on the debt?

Rounded to the nearest month, how long will it take a towns population to: a. Grow from 32,500 to 40,000 if the annual growth rate is 3%? b. Shrink from 40,000 to32,500 if the annual rate of decline...