Self join
- How many stops are in the database.
select count(id) from stops
- Find the id value for the stop 'Craiglockhart'
select id from stops where name = 'Craiglockhart'
- Give the id and the name for the stops on the '4' 'LRT' service.
select stops.id , stops.name from stops join route on stops.id = route.stop where num='4' and company = 'LRT'
- The query shown gives the number of routes that visit either London Road (149) or Craiglockhart (53). Run the query and notice the two services that link these stops h