Question: SQL: id name sales 1 1 1 | Finding Nemo 2 Finding Dory 3 Toy Story 3 41 Frozen 5 | A Bug's Life 6
SQL:
id name sales 1 1 1 | Finding Nemo 2 Finding Dory 3 Toy Story 3 41 Frozen 5 | A Bug's Life 6 | Mulan 7 Pocahontas 8 Moana 936 1 10211 1068 1272 3631 NULL 347 1 637 1 1 Which movies (from the above sample) will be returned by the following queries? Write, on the answer sheet, the id for each returned movie. If no movies are returned, write empty set?. 14. 15. 16. SELECT id FROM movies WHERE sales > 936 AND sales > 1200; SELECT id FROM movies WHERE sales = 1000; SELECT id FROM movies WHERE sales IN (1021, 1272); SELECT id FROM movies WHERE name = 'Frozen' AND sales = 936; SELECT id FROM movies WHERE name LIKE'_ulan%'; SELECT id FROM movies WHERE sales BETWEEN 1000 AND 600; 17. 18. 19. 20. SELECT id FROM movies WHERE name BETWEEN 'M' AND 'P
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
