Table Data
The data below will be used for the examples in the UNION, INTERSECT, and EXCEPT section:
Note
Movies table data:
| id | title | genre | release | rt_score |
|---|---|---|---|---|
| 1 | Interstellar | Science Fiction | 2014 | 73 |
| 2 | Pride and Prejudice | Novel | 2005 | 87 |
| 3 | Inception | Science Fiction | 2010 | 87 |
| 4 | Barbie | Comedy | 2023 | 88 |
| 5 | Marley & Me | Comedy | 2008 | 63 |
| 6 | The Proposal | Comedy | 2009 | 45 |
| 7 | Bridesmaids | Comedy | 2011 | 90 |
| 8 | The Guardian | Drama | 2006 | 37 |
Note
More_Movies table data:
| id | title | genre | release | rt_score |
|---|---|---|---|---|
| 1 | Interstellar | Science Fiction | 2014 | 73 |
| 2 | Pride and Prejudice | Novel | 2005 | 87 |
| 3 | Inception | Science Fiction | 2010 | 87 |
| 4 | Barbie | Comedy | 2023 | 88 |
| 5 | Marley & Me | Comedy | 2008 | 63 |
| 6 | The Proposal | Comedy | 2009 | 45 |
| 7 | Bridesmaids | Comedy | 2011 | 90 |
| 8 | The Guardian | Drama | 2006 | 37 |
| 9 | Mission: Impossible - Rogue Nation | Action | 2015 | 94 |
| 10 | The Last Dragon | Action | 1985 | 61 |
| 11 | Avatar | Action | 2009 | 82 |
| 12 | Gone Girl | Thriller | 2014 | 87 |
| 13 | Double Jeopardy | Thriller | 1999 | 28 |