Photo by Maxim Tolchinskiy on Unsplash
Greenhouse gas emissions attributable to products—from food to sneakers to appliances—make up more than 75% of global emissions. -The Carbon Catalogue
Our data, which is publicly availably on nature.com, contains product carbon footprints (PCFs) for various companies. PCFs are the greenhouse gas emissions attributable to a given product, measured in CO2 (carbon dioxide equivalent).
This data is stored in a PostgreSQL database containing one table, prouduct_emissions
, which looks at PCFs by product as well as the stage of production these emissions occured in. Here's a snapshot of what product_emissions
contains in each column:
product_emissions
product_emissions
field | data_type |
---|---|
id | VARCHAR |
year | INT |
product_name | VARCHAR |
company | VARCHAR |
country | VARCHAR |
industry_group | VARCHAR |
weight_kg | NUMERIC |
carbon_footprint_pcf | NUMERIC |
upstream_percent_total_pcf | VARCHAR |
operations_percent_total_pcf | VARCHAR |
downstream_percent_total_pcf | VARCHAR |
You'll use this data to examine the carbon footprint of each industry in the dataset!
-- Start coding here...
SELECT industry_group, COUNT(*) AS count_industry, ROUND(SUM(carbon_footprint_pcf), 1) AS total_industry_footprint
FROM product_emissions
GROUP BY industry_group, year
HAVING year = 2017
ORDER BY total_industry_footprint DESC;
The most recent year data was collected was 2017. The Materials industry_group has 11 companies and emits the highest amount of carbon emissions. The Capital Goods industry_group, despite only having four companies, emits the second most highest amount of carbon emissions in this dataset.