CODE EXAMPLE FOR SQL

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;