Project 1

ER DIAGRAM:

PROJECT:

1)AFTER APLLYING DISCOUNT CODE:

2)

3)Wishlists: query: SELECT customers.customer_Name,wishlists.product_1,wishlists.product_2,wishlists.product_3 FROM wishlists INNER JOIN customers ON wishlists.customer_id=customers.customer_id

5)customer reviews:SELECT product.Product_name , customers.customer_Name,product.Cost,product.Ratings,product.Reviews FROM product INNER JOIN customers ON product.Product_id=customers.Product_id

6)

for discounts : query :SELECT *, (Cost-200) AS DISCOUNTED_PRICE FROM product;

avgratings, totalratings, reviews for ratings, review country, ARE available in table

ONsale query:SELECT *, CASE WHEN Quantity>0 THEN 'ON_SALE' WHEN Quantity<0 THEN 'OUT_OF_STOCK' END AS AVAILABILTY FROM product

categories, brands, images, questions with answers about the products, description, tags, related products ids:

query:SELECT product.Product_name ,product.Cost, categories.Brand,categories.Product_description FROM product INNER JOIN categories ON product.Product_id=categories.Product_id

7)

8)Select customer_Name, Date_Of_Delivery, CASE WHEN Order_Status=1 THEN 'ORDERED' WHEN Order_Status=2 THEN 'PACKED' WHEN Order_Status=3 THEN 'SHIPPED' WHEN Order_Status=4 THEN 'DELIVERED' END AS Order_Status FROM orders

9)SELLERS