Embedded Files
About This Table
About This Table
This SQL output ranks the top 10 houseplants by VOC (Volatile Organic Compound) removal efficiency, calculated as the total micrograms (μg) of VOCs removed per square centimeter (cm²) of leaf surface area.
The query uses the ROUND function and a NULLIF safeguard to avoid division errors, then sorts the plants in descending order of VOC efficiency. This helps highlight plants that clean indoor air most effectively relative to their size.
Key Terms:
total_voc_removed – Combined removal of benzene, TCE, and formaldehyde.
leaf_surface_area_cm2 – Total leaf area used for normalization.
voc_efficiency – VOCs removed per cm² (μg/cm²), used for ranking.
This view is beneficial for identifying compact yet high-performing plants, which are ideal for small indoor spaces where air quality is a concern.
Page updated
Google Sites
Report abuse