Project: Analyzing Industry Carbon Emissions

DataFrameas

carbon_emissions_by_industry

variable

-- Find the most recent date 
SELECT MAX(year)
FROM product_emissions;

-- Complete the query
SELECT industry_group,
	COUNT(DISTINCT company) AS num_companies,
	ROUND(SUM(carbon_footprint_pcf), 1) AS total_industry_footprint
FROM product_emissions
WHERE year IN (SELECT MAX(year) FROM product_emissions)
GROUP BY industry_group
ORDER BY total_industry_footprint DESC;