What will be the output of following code ?

mysql> SELECT LCASE('INFORMATICS PRACTICES CLASS 11TH'); 

What will be the output of following code ?

mysql> SELECT UCASE('Computer studies');

What will be the output of following code ?

mysql> SELECT CONCAT(LOWER('Class'), UPPER('xii'));

Find the output of the following SQL Query :

SELECT ROUND(7658.345, 2);

Find the output of the following SQL Query :

SELECT MOD(ROUND (13.9, 0), 3);

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 the output produced by the following SQL commands:

(a) SELECT POW(2,3);

(b) SELECT ROUND(123.2345, 2) ,ROUND(342.9234,-1);

(c) SELECT LENGTH("Informatics Practices");

(d) SELECT YEAR("1979/11/26"), MONTH("1979/11/26"), MONTHNAME("1979/11/26"), DAY("1979/11/26");

(e) SELECT LEFT("INDIA", 3), RIGHT("Computer Science", 4);

(f) SELECT MID("Informatics", 3,4), SUBSTR("Practices", 3);

(g) SELECT CONCAT("You Scored", LENGTH("123") , "rank");

(h) SELECT ABS(-67.89);

(i) SELECT SQRT(625) + ROUND(1234.89, -3);

(j) SELECT MOD(56, 8);

Dr. Kavita has created a database for a hospital's pharmacy. The database includes a table named MEDICINE whose column (attribute) names are mentioned below:

MID: Shows the unique code for each medicine.

MED_NAME: Specifies the medicine name.

SUPP_CITY: Specifies the city where the supplier is located.

STOCK: Indicates the quantity of medicine available.

DEL_DATE: Specifies the date when the medicine was delivered.

Table: MEDICINE

MID	MED_NAME	SUPP_CITY	STOCK	DEL_DATE
M01	PARACETAMOL	MUMBAI	200	2023-06-15
M02	AMOXICILLIN	KOLKATA	50	2023-03-21
M03	COUGH SYRUP	BENGALURU	120	2023-02-10
M04	INSULIN	CHENNAI	135	2023-01-25
M05	IBUPROFEN	AHMEDABAD	30	2023-04-05

Write the output of the following SQL Queries.

I. Select LENGTH(MED_NAME) from MEDICINE where STOCK > 100;

II. Select MED_NAME from MEDICINE where month(DEL_DATE) = 4;

III. Select MED_NAME from MEDICINE where STOCK between 120 and 200;

IV. Select max(DEL_DATE) from MEDICINE;