SELECT COUNT(*) FROM stops

SELECT id FROM stops WHERE name='Craiglockhart'

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

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

SELECT pos, name FROM stops, route
  WHERE id=stop
    AND company='LRT'
    AND num='4'
 ORDER BY pos

SELECT company, num FROM route, stops
  WHERE stop=id
    AND name='Craiglockhart'

SELECT R1.company, R1.num
  FROM route R1, route R2
  WHERE R1.num=R2.num AND R1.company=R2.company
    AND R1.stop=115 AND R2.stop=137

SELECT R1.company, R1.num
  FROM route R1, route R2, stops S1, stops S2
  WHERE R1.num=R2.num AND R1.company=R2.company
    AND R1.stop=S1.id AND R2.stop=S2.id
    AND S1.name='Craiglockhart'
    AND S2.name='Tollcross'

SELECT S2.id, S2.name, R2.company, R2.num
  FROM stops S1, stops S2, route R1, route R2
  WHERE S1.name='Craiglockhart'
    AND S1.id=R1.stop
    AND R1.company=R2.company AND R1.num=R2.num
    AND R2.stop=S2.id

"Thanks to Sam Lafferty for solution
SELECT a.name Start_At, b.num FirstBus, b.company FBC,
       e.name Change_At, f.num SecondBus, f.company SBC,
       g.name Arive_At
 FROM  stops a, route b,
       stops c, route d,
       stops e, route f,
       stops g, route h
WHERE  a.id = b.stop                 
  AND  c.id = d.stop
  AND  e.id = f.stop
  AND  g.id = h.stop
  
  AND  b.num = d.num
  AND  b.company = d.company   

  AND  f.num = h.num
  AND  f.company = h.company   
  AND  c.name = e.name

  AND  a.name = 'Craiglockhart'
  AND  g.name = 'Sighthill'

  AND d.pos > b.pos
  AND h.pos > f.pos