Informatics Practices
Related Questions
Write a query to find out the sum, average, lowest and highest marks of the students in Student table grouped by STREAM.
Consider the table "Item" given below and give the outputs on the basis of it:
Table: ITEM
Itemno Iname Price (₹) Quantity 101 Soap 50 100 102 Powder 100 50 103 Facecream 150 25 104 Pen 50 200 105 Soapbox 20 100 (a) SELECT SUM(Price) FROM ITEM;
(b) SELECT AVG(Price) FROM ITEM;
(c) SELECT MIN(Price) FROM ITEM;
(d) SELECT MAX(Price) FROM ITEM;
(e) SELECT COUNT(Price) FROM ITEM;
(f) SELECT DISTINCT Price FROM ITEM;
(g) SELECT COUNT(DISTINCT Price) FROM ITEM;
(h) SELECT Iname, Price*Quantity FROM ITEM;
Write commands to display the system date.
Write a command to display the name of the current month.