SQL project
Budget: ₹600 – ₹1,500 INR
5 Queries, need it in 1 day.
1) This criterion is linked to a Learning Outcome1. List Top 3 products based on QuantityAvailable. (productid. productname. QuantityAvailable ). (3 Rows) [Note: Products]
2) This criterion is linked to a Learning Outcome2. Display EmailId of those customers who have done more than ten purchases. (EmailId. Total_Transactions). (5 Rows) [Note: Purchasedetails. products]
3) This criterion is linked to a Learning Outcome3. List the Total QuantityAvailable category wise in descending order. (Name of the category. QuantityAvailable) (7 Rows) [Note: products. categories]
4) This criterion is linked to a Learning Outcome4. Display ProductId. ProductName. CategoryName. Total_Purchased_Quantity for the product which has been sold maximum in terms of quantity? (1 Row) [Note: purchasedetails. products. categories]
5) This criterion is linked to a Learning Outcome5. Display the number of male and female customers in fastkart. (2 Rows) [Note: roles. users]
1) This criterion is linked to a Learning Outcome1. List Top 3 products based on QuantityAvailable. (productid. productname. QuantityAvailable ). (3 Rows) [Note: Products]
2) This criterion is linked to a Learning Outcome2. Display EmailId of those customers who have done more than ten purchases. (EmailId. Total_Transactions). (5 Rows) [Note: Purchasedetails. products]
3) This criterion is linked to a Learning Outcome3. List the Total QuantityAvailable category wise in descending order. (Name of the category. QuantityAvailable) (7 Rows) [Note: products. categories]
4) This criterion is linked to a Learning Outcome4. Display ProductId. ProductName. CategoryName. Total_Purchased_Quantity for the product which has been sold maximum in terms of quantity? (1 Row) [Note: purchasedetails. products. categories]
5) This criterion is linked to a Learning Outcome5. Display the number of male and female customers in fastkart. (2 Rows) [Note: roles. users]