<< Back to Database Engineering Portfolio

Assignment 2

    write a SQL query to list the titles of all movies released in 2014.

  1. SELECT title FROM movies WHERE year = 2014;

    2. write a SQL query to determine the birth year of Emma Stone.

  2. SELECT birth FROM people WHERE name = 'Emma Stone';

    3. write a SQL query to list the titles of all movies with a release date on or after 2018, in alphabetical order

  3. SELECT title FROM movies WHERE year >= 2018 ORDER BY title ASC;

    4. write a SQL query to determine the number of movies with an IMDb rating of 8.4.

  4. SELECT COUNT(rating) AS Amount FROM ratings WHERE rating = 8.4;