Select all data from all movie theaters and, additionally, the data from the movie that is being shown in the theater (if one is being shown).
| VERBOSE
| SELECT code, name, film FROM theatres
| SELECT code, title, rating FROM film
| RENAME code film
| LEFTJOIN film
6 rows 0 msec
| SELECT code, name, film FROM theatres
| SELECT code, title, rating FROM film
| RENAME code film
| LEFTJOIN film
6 rows 0 msec
| code | name | film | title | rating |
|---|---|---|---|---|
| 1 | Odeon | 5 | North By Northwest | |
| 2 | Imperial | 1 | Citizen Kane | PG |
| 3 | Majestic | |||
| 4 | Royale | 6 | The Last Tango in Paris | NC-17 |
| 5 | Paraiso | 3 | The Wizard of Oz | G |
| 6 | Nickelodeon |