Product_idProduct_nameCategory Mfg_dateExp_DteProduct_price01Dairy MilkChoclateJunk2,Aug, 20192aug, 20208002Lipton Tea BagsNot junk 2,jan 20192, jan 202016003Kurkurejunk2, april 29192, april, 20213004Shezan JuiceJunk3,Aug, 20193,aug, 20203006Olpers MilkNot junk3,april, 20183,april, 2020350Canteen_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.

The given problem is related to database SQL queries where the requirement is to create the table…

Answered: 1: Write query to create canteen_table.…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

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 2919	2, april, 2021	30
04	Shezan Juice	Junk	3,Aug, 2019	3,aug, 2020	30
06	Olpers Milk	Not junk	3,april, 2018	3,april, 2020	350

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.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 8 steps with 8 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions