SELECT id FROM stops WHERE name = 'Craiglockhart' SELECT id, name FROM route JOIN stops ON stops.id = route.stop WHERE num = 4 AND company = 'LRT' ORDER BY pos SELECT ...
SELECT yr FROM movie WHERE title="Citizen Kane" SELECT id, title, yr FROM movie WHERE title LIKE "%Star Trek%" ORDER BY yr SELECT id FROM actor WHERE name = 'Glenn ...