Quantum Labs Chemical Inventory

Completed

Incomplete

Not Attended

Share

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.

notAttendedQuestion - 1

List chemicals with hazard_level ‘High’.

notAttendedQuestion - 2

Calculate total chemical quantity per storage_room.

notAttendedQuestion - 3

List all chemicals sorted by quantity_liters in descending order to check which chemicals are stored in largest amounts.

Prev
View Questions
Next
Code Editor
Table Name: chemical_inventory
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

>>> Submit Your Query to validate