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;
