Blog

Show all movies where the title starts with “B” but does not start with “Bo”. Order by title (A-Z). Image Long Description Results Grid idmovies title genre year director rating numrating 28 Back to the Future Drama 1985 Robert Zemeckis 9 250000 23 Beyond the Sea Drama 2004 Kevin Spacey 7 13091 6 Blade Runner Thriller 1982 Ridley Scott 9 484746 25 Braveheart Drama 1995 Mel Gibson 8 81328 NULL NULL NULL NULL NULL NULL NULL

Show the top 10 highest-rated movies. Use LIMIT. Order by rating in descending order. Image Long Description Results Grid idmovies title genre year director rating numrating 26 Seven Samurai Drama 1954 Akira Kurosawa 10 75049 35 Selma Drama 2014 Ava DuVernay 10 853049 13 The Shawshank Redemption Crime 1994 Frank Darabont 10 999486 34 The Matrix Thriller 1999 Lana Wachowski 9 940593 4 The Deer Hunter Drama 1978 Michael Cimino 9 905335 5 Amadeus Drama 1984 Milos Forman 9 558043 28 Back to the Future Drama 1985 Robert Zemeckis 9 250000 8 The Usual Suspects Crime 1995 Bryan Singer 9 779489 9 Chinatown Mystery 1974 Roman Polanski 9 227235 17 Deliverance Adventure 1972 John Boorman 9 870394

Show all movies that are either in the “Comedy” or “Action” genre and have more than 100,000 ratings. Use IN to determine genre. Order by the number of ratings, high to low. Image Long Description Results Grid idmovies title genre year director rating numrating 29 Swept Away Comedy 1974 Lina Wertmuller 7 650984 22 Aliens Action 1986 James Cameron 8 511613 30 American Splendor Comedy 2003 Shari Springer Berman 7 399205 11 Annie Hall Comedy 1977 Woody Allen 8 203875 32 Wayne’s World Comedy 1992 Penelope Spheeris 7 203551 NULL NULL NULL NULL NULL NULL NULL

Display all movies directed by Quentin Tarantino, Martin Scorsese, or Christopher Nolan. Order by director (A-Z). Image Long Description Results Grid idmovies title genre year director rating numrating 19 The Prestige Thriller 2006 Christopher Nolan 7 586328 NULL NULL NULL NULL NULL NULL NULL

List all unique genres in the database (A-Z). Image Long Description Results Grid genre Action Adventure Animation Comedy Crime Drama Horror Mystery Romance Thriller

What values for CountryID do the suppliers Sugarplum and Periwinkle have after the UPDATE statement executes? Supplier SupplierID CompanyName ContactName CountryID 2 Oshkosh Bgosh Martina Perry 2 3 LittleGuppies Cierra Martinez 1 4 Sugarplum Miranda Adams NULL 5 Rosebuds for Girls Adan Stevens 2 6 Lin Ming C. Linda Ming 3 7 Periwinkle Sarah Gomez NULL UPDATE SupplierSET CountryID = 2WHERE CountryID IS NULL;

Which suppliers remain in the Supplier table after the DELETE statement executes? Supplier SupplierID CompanyName ContactName CountryID 2 Oshkosh Bgosh Martina Perry 2 3 LittleGuppies Cierra Martinez 1 4 Sugarplum Miranda Adams 2 5 Rosebuds for Girls Adan Stevens 2 6 Lin Ming C. Linda Ming 3 7 Periwinkle Sarah Gomez 2 DELETE FROM SupplierWHERE CountryID

A/An (blank) is a rule enforced on a table’s data.

In the Reservation table below, a room may be reserved several times, so the RoomNumber column is not unique. To ensure that a room can only be reserved by only one guest for the day, the minimal primary key consists of which columns? Reservation RoomNumber DateOfStay Guest ModeOfPayment 201 2020-01-10 Guest A cash 202 2020-01-15 Guest B cash 203 2020-01-18 Guest C credit card 204 2020-01-18 Guest D credit card 205 2020-01-19 Guest D credit card 206 2020-01-21 Guest E cash

Show the average rating for movies in each genre. Image Long Description Results Grid gen_title AVG(rating.rev_rating) Action 7.02308 Adventure 7.13023 Animation 6.59167 Comedy 7.45000 Crime 6.78182 Drama 6.84239 Horror 7.12500 Music 6.64444 Mystery 6.74048 Romance 7.35000 Thriller 6.75417 War 7.08333