Instruction: Give me all the top rated and the most watched James Bond movies.
SELECT name, rate, views FROM movies WHERE rate >24
UNION
SELECT name, rate, views FROM movies WHERE views>1,000,000
(Note: Columns should be the same to work and this command will remove duplicate entries.)
| name | rate | views |
|---|---|---|
| Dr. No | 24 | 1,000,000 |
| FROM RUSSIA WITH LOVE | 23 | 2,000,000 |
| GOLDFINGER | 22 | 3,000,000 |
| THUNDERBALT | 21 | 4,000,000 |
| YOU ONLY LIVE TWICE | 20 | 5,000,000 |
| On HER MAJESTY'S SECRET SERVICE | 19 | 6,000,000 |
| Diamonds Are Forever | 18 | 7,000,000 |
| LIVE AND LET DIE | 17 | 8,000,000 |
| MOONRAKER | 16 | 8,000,000 |
| FOR YOUR EYES ONLY | 15 | 8,000,000 |
| OCTOPUSSY | 14 | 8,000,000 |
| NEVER SAY NEVER AGAIN | 13 | 8,000,000 |
| A VIEW TO A KILL | 12 | 8,000,000 |
| THE LIVING DAY LINGTS | 5 | 8,000,000 |
| LICENSE TO KILL | 6 | 8,000,000 |
| GOLDEN EYE | 1 | 10,000,000 |
| Tomorrow Never Dies | 2 | 10,000,000 |
| The World Is Not Enough | 3 | 10,000,000 |
| DIE ANOTHER DAY | 4 | 10,000,000 |
| CASINO ROYALE | 7 | 9,000,000 |
| QYUANTUM OF SOLACE | 8 | 9,000,000 |
| Skyfall | 9 | 9,000,000 |
| Spectre | 10 | 9,000,000 |
| No Time to Die | 11 | 9,000,000 |
No comments:
Post a Comment