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

SQL
0

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

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;
Posted by: Guest on May-09-2021

Code answers related to "Find the names of sailors who have reserved a red boat, and list in the order of age"

Code answers related to "SQL"

Browse Popular Code Answers by Language