SELECT * FROM product_emissions;

SELECT * FROM product_emissions WHERE company LIKE 'Coca-Cola%' LIMIT 6;

SELECT MAX(year) FROM product_emissions;

SELECT industry_group, ROUND(SUM(carbon_footprint_pcf),0) AS total_industry_footprint FROM product_emissions GROUP BY industry_group, year HAVING year = 2017 ORDER BY total_industry_footprint DESC;

SELECT industry_group, COUNT(*) AS count_industry FROM product_emissions GROUP BY industry_group, year HAVING year = 2017 ORDER BY count_industry DESC;

SELECT industry_group, company, product_name FROM product_emissions WHERE industry_group = 'Capital Goods' AND year = 2017;

SELECT product_name, company, upstream_percent_total_pcf, operations_percent_total_pcf, downstream_percent_total_pcf FROM product_emissions WHERE company = 'Daikin Industries, Ltd.' AND year = 2017;

SELECT * FROM product_emissions;

import plotly.express as px

px.bar(product_emissions_df, x= "country")

SELECT country, ROUND(SUM(carbon_footprint_pcf),0) AS total_country_footprint FROM product_emissions GROUP BY country ORDER BY total_country_footprint DESC;

px.bar(emissions_country, x="country", y= "total_country_footprint")

SELECT company, carbon_footprint_pcf FROM product_emissions WHERE country = 'Spain' ORDER BY carbon_footprint_pcf DESC;