This repository was archived by the owner on Mar 12, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathAtividade.txt
More file actions
23 lines (23 loc) · 2.36 KB
/
Atividade.txt
File metadata and controls
23 lines (23 loc) · 2.36 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
_____________________________________________________________________________________________________|
Quantas vezes Natalie Portman foi indicada ao Oscar? Quantas ela ganhou? |
R: Sim, ela ganhou 1 vezes |
SELECT COUNT(*) FROM `vencedoresdooscar` WHERE Nominee = 'Natalie Portman' |
SELECT COUNT(*) FROM `vencedoresdooscar` WHERE Nominee = 'Natalie Portman' AND Won = 'Yes' |
|
|
_____________________________________________________________________________________________________|
Amy Adams já ganhou algum Oscar? |
R:Não |
SELECT COUNT(*) FROM `vencedoresdooscar` WHERE Nominee = 'Amy Adams' AND Won = 'Yes' |
|
_____________________________________________________________________________________________________|
Toy Story 3 ganhou Oscar em quais anos? |
SELECT Year, Won FROM 'vencedoresdooscar` WHERE Nominee = 'Toy Story 3' AND WON = 'YES' |
2010 |
|
_____________________________________________________________________________________________________|
Quem tem mais Oscars: a categoria "Melhor Ator" ou "Melhor Filme"? |
R:Os melhor atores gannharam 85 e o melhor filme 83 |
SELECT COUNT(*) FROM `vencedoresdooscar` WHERE category = 'Actor -- Leading Role' AND WON = 'YES'; |
SELECT COUNT(*) FROM `vencedoresdooscar` WHERE category = 'Best Picture' AND WON = 'YES'; |
_____________________________________________________________________________________________________|