SQLZOO SELF JOIN

1: How many stops are in the database

SELECT COUNT(*) FROM stops

2:Find the id value for the stop 'Craiglockhart'

SELECT id FROM stops WHERE name = 'Craiglockhart'

3:Give the id and the name for the stops on the '4' 'LRT' service.

SELECT id,name FROM stops JOIN route ON id = stop WHERE num = 4 AND company = 'LRT'

4:The query shown gives the number of routes that visit either London Road (149) or Craiglockhart (53). Run the query and notice the