You are hired by a chain of online retail stores“ Fastkart”. They have provided you with “Fastkart”...

Question

You are hired by a chain of online retail stores“
Fastkart”. They have provided you with “Fastkart” database and seek answers to the following queries as the results from these queries will help the company in making data-driven decisions that will impact the overall growth of the online retail stores.

All the questionscomes under MYSQL and the queries should be executed in MYSQL. (SQL Script -
Fastkart.sql
)

All Questions carry 8 marks. Total Marks (8 x 10) = 80

Note:In case the file gets open in the browser, Please copy the entire text(including comment) and paste it on MySQL workbench. Execute all the commands to create a database schema. In case, if you are able to download the file, please use MySQL Workbench, File>open SQL Script>FastKart.SQL and then execute all the statements to create a database schema.

All Questions carry 8 marks. Total Marks (8 x 10) = 80

sql1-5-ques-ktcxtwx1.jpg sql-6-10-ques-th35odex.jpg fastkart-2-2-0l3izg02.sql

Aditi · Accepted Answer

1. List Top 3 products based on QuantityAvailable. (productid, productname, QuantiSELECT ProductId,ProductName, QuantityAvailable FROM Products
order by QuantityAvailable DESC limit 3;
2. SELECT pd.EmailId,pd.QuantityPurchased as Total_Transactions
FROM PurchaseDetails pd INNER JOIN Products p
ON pd.ProductId=p.ProductId GROUP by EmailId
HAVING count(QuantityPurchased)>10 ORDER by Total_Transactions DESC;
3. Select c.CategoryName as NameOfTheCategory, p.

You are hired by a chain of online retail stores“ Fastkart”. They have provided you with “Fastkart” database and seek answers to the following queries as the results from these queries will help...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment