Skip to content

add text here

In the SQL cell below:

  • Set the source to 'Course Databases' to query databases used in SQL courses.
  • Set the source to 'DataFrames and CSVs' to query this course's CSV files (if any) with SQL
  • Write SQL! Note that you cannot run queries that modify the database.
Spinner
DataFrameas
df
variable
with countMovie as 
(
	select count(*) as NoOfMovies, cinema.films.country 
		from cinema.films
	group by cinema.films.country
) select * from countMovie where NoOfMovies>=20 order by country;