The Rotterdam Metro is the part of the Rotterdam public transport network (RET).

Question

The Rotterdam Metro is the part of the Rotterdam public transport network (RET). The metro map shows the three original Metro lines -Northern, Western and Eastern- and the original metro stops The map shows two zones, with all stations outside of Zone 1 being in Zone 2. Rodenriis Meijersplein Blijdorp Centraal Northern Line Zone 1 Coolhaven Blaak Oostplein Marconiplein Parkweg Capelsebrug Eastern Line Tussenwater Western Line Figure 1: A map of the original Rotterdam RET Metro A journey from Tussenwater to Parkweg travels in one zone, as does a journey from Blaak to Blijdorp Travelling from Rodenrijs to Marconiplein covers two zones, with the start station in Northern Line Zone 2 and finishing within Zone 1. A trip from Centraal to Capelsebrug (Zone 1 to Eastern Line Zone 2) also covers two zones. Some trips travel through three zones, for example, Capelsebrug to Rodenrijs, which travels through Eastern Line Zone 2, Zone 1 and Northern Line Zone 2 (three zones in total) Zones 1 Zone 2 Zones 3 Zones Cost () 3 5 8 Table 1: Rotterdam Metro Fares

Explanation / Answer

If you have any doubts, please give me comment...

-- 1)

SELECT linename, COUNT(stationID)

FROM line l, station s

WHERE l.lineID = s.lineID;

-- 2)

SELECT username, COUNT(journeyID)

FROM customer c, journey j

WHERE c.customerID = j.customerID;

-- 3)

SELECT stationName, linename

FROM station s,line l

WHERE s.lineID = l.lineID AND stationName LIKE '%plein%'

ORDER BY linename;

-- 4)

SELECT username, SEC_TO_TIME(SUM(TIMESTAMPDIFF(SECOND, (endTime-startTime)))) AS travel_time

FROM customer c, journey j

WHERE c.customerID = j.customerID;

--5)

SELECT username

FROM customer c, journey j

WHERE c.customerID = j.customerID AND fareType = 0 AND datename(month, startTime) = 'January' AND YEAR(startTime) = 2018;

6)

SELECT f.stationName

FROM line l, station f, station t, journey j

WHERE l.lineID = f.lineID AND f.stationID = j.startStationID AND t.stationID = j.endStationID AND linename ='Northern' AND f.stationName ='Centraal' AND t.stationName = 'Rodenrijs';

-- 7)

SELECT journeyID, s.stationName, sl.linename, e.stationName, el.linename

FROM journey j, station s, line sl, station e, line el

WHERE j.startStationID = s.stationID AND s.lineID = sl.lineID AND e.lineID = el.lineID AND j.endStationID = e.stationID AND TIMESTAMPDIFF(MINUTE, (endTime-startTime))>12;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.