Search
 
SCRIPT & CODE EXAMPLE
 
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;
 
PREVIOUS NEXT
Tagged: #Find #names #sailors #reserved #red #list #order #age
ADD COMMENT
Topic
Name
7+4 =