Find sailors with a higher rating than all sailors younger than 21 A. Write a SQL...

Transcribed Image Text:

Find sailors with a higher rating than all sailors younger than 21 A. Write a SQL query to answer the question using OP ALL B. Write a SQL query Close (Ctrl+X) question using NOT EXISTS C. Consider the following instance of Sailors. What are the results of running the query in A and B. SID 1 2 3 4 5 لیا SNAME RATING AGE Dustin 7 Zorba 10 Rusty 5 Dustin 7 Dustin 6 45 35 35 15 20 Find sailors with a higher rating than all sailors younger than 21 A. Write a SQL query to answer the question using OP ALL B. Write a SQL query Close (Ctrl+X) question using NOT EXISTS C. Consider the following instance of Sailors. What are the results of running the query in A and B. SID 1 2 3 4 5 لیا SNAME RATING AGE Dustin 7 Zorba 10 Rusty 5 Dustin 7 Dustin 6 45 35 35 15 20

Answer rating: 100% (QA)

To find sailors with a higher rating than all sailors younger than 21 you can use the ALL and NOT EX... View the full answer