Completed
Incomplete
Not Attended
Completed
Incomplete
Not Attended
Quantum Labs is a cutting-edge research facility that handles various chemicals for
experiments and production. The lab manager must ensure safety by keeping track of highhazard chemicals, monitoring the quantity of chemicals in each storage room, and prioritizing
chemicals stored in large amounts for routine checks. Your role is to help the lab team manage
chemical inventory efficiently using SQL.
List chemicals with hazard_level ‘High’.
Calculate total chemical quantity per storage_room.
List all chemicals sorted by quantity_liters in descending order to check which chemicals are stored in largest amounts.
| chemical_id | chemical_name | quantity_liters | storage_room | hazard_level |
|---|---|---|---|---|
| 1 | Sulfuric Acid | 50.0 | Room A | High |
| 2 | Sodium Chloride | 100.0 | Room B | Low |
| 3 | Ethanol | 75.0 | Room A | Medium |
| 4 | Acetone | 60.0 | Room C | High |
| 5 | Hydrochloric Acid | 40.0 | Room B | High |
