Product_id Product_name Category Mfg_date Exp_Dte Product_price 01 Dairy Milk Choclate Junk 2,Aug, 2019 2aug, 2020 80 02 Lipton Tea Bags Not junk 2,jan 2019 2, jan 2020 160 03 Kurkure junk 2, april...

Canteen_table

• 
  1: Write query to create canteen_table. Put check on category values as only “junk” and “Not junk”.
  

• Change colum name of product_price to unit_price.

• Display products manufactured between 1, jan 2019 to 1, May 2019.

• Display count of only junk food items in canteen_table with alias name as “junk Food Count”.

• Display Count Of both Junk food and not junk food products whose count is greater then 1.