好的,在这个例子中,巴士101从街道1,2和5按照这个顺序行驶。从街道3,2,1,按这个顺序返回的巴士。= 3 -> the bus 101 passx = 3, y = 5 -> the bus 101 don't pass
所以,我的发现总线的id_street = r1.id and rg2.id_street = r2.id and r1.id = 1 and r2.id = 5 and b.bus_id = rg1.i
SELECT DISTINCT CITY FROM STATION WHERE City LIKE 'a%'SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE 'e%'SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE 'i%'SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE 'o%'SELECT DISTINCT CITY FRO