0514

[zoey2111]

List all directors of Pixar movies (alphabetically), without duplicates SELECT DISTINCT director FROM movies ORDER BY director ASC;

[zoey2111]

List the last four Pixar movies released (ordered from most recent to least) SELECT title, year FROM movies ORDER BY year DESC LIMIT 4;

[zoey2111]

List the next five Pixar movies sorted alphabetically SELECT title FROM movies ORDER BY title ASC LIMIT 5 OFFSET 5; LIMIT 5: This limits the number of results returned by the query to 5. Essentially, it tells the database to only give back the top 5 records after sorting.

OFFSET 5: This is used to skip the first 5 records in the results. An OFFSET of 5 means, "Start giving me results from the 6th record."

[zoey2111]

• • • -pay attention to FROM

      List all the cities west of Chicago, ordered from west to east SELECT city FROM North_american_cities WHERE longitude <= -87.629798 ORDER BY longitude ASC;

      SELECT city, longitude FROM north_american_cities WHERE longitude < -87.629798 ORDER BY longitude ASC;

      zoey2111 commented 2 months ago

      SELECT city,population FROM North_american_cities WHERE country = 'Mexico', ORDER BY population DESC LIMIT 2;

      zoey2111 commented 2 months ago

      Find the domestic and international sales for each movie SELECT title, domestic_sales, international_sales FROM movies JOIN boxoffice ON id = movie_id;

      zoey2111 commented 2 months ago

      Show the sales numbers for each movie that did better internationally rather than domestically SELECT title, domestic_sales, international_sales FROM movies JOIN boxoffice ON id = movie_id WHERE international_sales > domestic_sales;

      • © Githubissues.
      • Githubissues is a development platform for aggregating issues.

[zoey2111]

SELECT city,population FROM North_american_cities WHERE country = 'Mexico', ORDER BY population DESC LIMIT 2;

[zoey2111]

Find the domestic and international sales for each movie SELECT title, domestic_sales, international_sales FROM movies JOIN boxoffice ON id = movie_id;

[zoey2111]

Show the sales numbers for each movie that did better internationally rather than domestically SELECT title, domestic_sales, international_sales FROM movies JOIN boxoffice ON id = movie_id WHERE international_sales > domestic_sales;