Assignment for Anu DBMS SQL 23-02-2022

/**
Assignment for Anu DBMS SQL 23-02-2022
*/
Suppose there are categories of products like Mobiles, Television, refrigerators, etc.
Those products are tagged under Electronics.
There are several tags like Electronics, Home, Baby, Skincare, etc.
There are many products of different categories and tags
There are many coupons for availing of discounts during placing the order.
Let a user has purchased multiple products on a sale using a coupon.

Show the last purchased products during the sale with user information, order information, product information, payment information, product category, tag.
Show all the products list available for purchase with user information, order information, product information, payment information, product category, tag.
*(use relevant information for the product and related tables )