A database table, 2018MOV, is used to keep a record of movie details.
CatNo | Title | Genre1 | Genre2 | Blu-ray | DVD | Streaming |
18m01 | Power Rangers | Adventure | Fantasy | Yes | No | Yes |
18m02 | Baywatch | Comedy | Drama | Yes | No | Yes |
18m03 | Table 19 | Comedy | Drama | Yes | Yes | No |
18m04 | Wonder Woman | Action | Fantasy | Yes | No | Yes |
18m05 | Justice League | Action | Fantasy | Yes | Yes | Yes |
18m06 | Twilight | Thriller | Action | Yes | Yes | No |
18m07 | Ant Man | Action | Fantasy | No | Yes | No |
18m08 | Venice Beach | Action | History | No | Yes | No |
18m12 | Fast Five | Action | Thriller | No | Yes | No |
18m15 | King Kong | Adventure | Fantasy | No | Yes | Yes |
18m16 | Transformers: The Last Knight | Action | Sci-Fi | Yes | Yes | Yes |
18m17 | The Dark Tower | Fantasy | Sci-Fi | Yes | Yes | No |
18m19 | Beauty and the Beast | Fantasy | Romance | Yes | Yes | Yes |
18m21 | The Mummy | Action | Fantasy | No | No | Yes |
18m22 | Star Wars: Episode VIII | Sci-Fi | Action | Yes | No | Yes |
18m23 | Guardians of the Galaxy | Action | Sci-Fi | Yes | Yes | Yes |
18m26 | Thor | Action | Sci-Fi | No | Yes | Yes |
18m27 | Twilight | Fantasy | Sci-Fi | No | No | Yes |
18m30 | Beneath | Action | Fantasy | Yes | No | No |
18m31 | Despicable Me | Animation | Action | Yes | Yes | No |
Complete the structured query language (SQL) to return the category number and title for all Comedy movies.
SELECT CatNo, Title
.................................................. 2018MOV
WHERE Genre1 = ..................................................;
[2]
Did this page help you?