a)Create 3 tables(product_categories,products,product_sale) with primary key,foreign key in each table and provide data from all the 3 tables using Inner join,Left join,right join and full join....


Do all parts and attach screenshots


a)Create 3 tables(product_categories,products,product_sale) with primary key,foreign key in each<br>table and provide data from all the 3 tables using Inner join,Left join,right join and full join.<br>b)Form the above 3 tables provide a daily product wise sale report(using SQL query) i.e in the month<br>of Jan 2022 product wise sale count,profits,profit %,average bill.<br>C)Also generate an overall wise sale report(using SQL query) i.e,cash payment,card payment,total<br>sales amount,total product count, avg bill amount for each week in the month of JAN 2022.<br>

Extracted text: a)Create 3 tables(product_categories,products,product_sale) with primary key,foreign key in each table and provide data from all the 3 tables using Inner join,Left join,right join and full join. b)Form the above 3 tables provide a daily product wise sale report(using SQL query) i.e in the month of Jan 2022 product wise sale count,profits,profit %,average bill. C)Also generate an overall wise sale report(using SQL query) i.e,cash payment,card payment,total sales amount,total product count, avg bill amount for each week in the month of JAN 2022.

Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here