Question

Consider a table PRODUCT with the following data:

Table: PRODUCT
SNO	Itemname	Company	Stockdate	Price	Discount
1	Monitor	HP	2021-12-20	15499.739	15
2	Webcam	Logitech	2020-02-03	4890.90	5
3	Keyboard	Logitech	2022-08-19	1878.985	30
4	Mouse	HCL	2021-05-16	1200.00	7
5	Speakers	iBall	2021-10-19	NULL	25

Write SQL queries using SQL functions to perform the following operations:

1. Display the first 3 characters of all Itemnames.
2. Display the names of all items whose Stockday is "Monday".
3. Display the total price of all the products.
4. Display the maximum Price.
5. Display the average Price of all the products by the company named 'Logitech'.

Answer 1

1. Select left(item name,3) from product;
2. Select item name from product where day name (stock date) = 'Monday';
3. Select sum(price) from product;
4. Select max(price) from product;
5. Select avg(price) from product where company = 'Logitech';