SQL: SELECT, FROM, ORDER BY
Exercise
Today we will use Structured Query Language (SQL) to pull data from a movie database. SQL, like spreadsheets, is an indispensable tool for data analysts.
Demo: SELECT
, FROM
, ORDER BY
, ASC
, DESC
Practice: Constructing SQL Statements
Construct the appropriate SQL statements to satisfy each of the following requests. Use the to test your statements.
List all movies in the movies
table. Include all columns.
List all movies, but include only title
and year
columns.
List all movies by ascending year
. Include all columns.
List all movies by descending vote_count
. Include only title
and vote_count
columns.
Demonstrate your executed SQL statements with an instructor.
Continue work on the Data Analytics Certificate on Coursera ()