Skip to content
New Workbook
Sign up
SQL Test
Spinner
Data frameavailable as
companies
variable
SELECT * 
FROM public.companies
Spinner
Data frameavailable as
df
variable
SELECT *
FROM main.product_emissions
Spinner
Data frameavailable as
product_emissions
variable
SELECT year, SUM(carbon_footprint_pcf) AS carbon_footprint_pcf_by_year
FROM public.product_emissions
GROUP BY year
Spinner
Data frameavailable as
df1
variable
Spinner
Data frameavailable as
sales
variable
SELECT * 
FROM public.sales
Spinner
Data frameavailable as
df2
variable
SELECT MAX(SUBSTRING(date,1, 10)) AS max_date, MIN(SUBSTRING(date,1,10)) AS min_date,
FROM main.sales
Spinner
Data frameavailable as
students
variable
SELECT * FROM public.students