Find the names of sailors who have reserved a red boat, and list in the order of age

Average Anteater answered on May 9, 2021 Popularity 4/10 Helpfulness 2/10

Comment

select s.name, s.age
from sailors s, reserves r, boats b
where s.id = r.sId and r.bId = b.id and b.color = 'red'
order by s.age;

Popularity 4/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: find list names red reserved sql

Link to this answer
Share Copy Link

Contributed on May 09 2021

Average Anteater

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.