SQL Test — DataLab

Data frameas

companies

variable

SELECT * 
FROM public.companies

Data frameas

df

variable

SELECT *
FROM main.product_emissions

Data frameas

product_emissions

variable

SELECT year, SUM(carbon_footprint_pcf) AS carbon_footprint_pcf_by_year
FROM public.product_emissions
GROUP BY year

Data frameas

df1

variable

Data frameas

sales

variable

SELECT * 
FROM public.sales

Data frameas

df2

variable

SELECT MAX(SUBSTRING(date,1, 10)) AS max_date, MIN(SUBSTRING(date,1,10)) AS min_date,
FROM main.sales

Data frameas

students

variable

SELECT * FROM public.students