SELECT * FROM cd.bookings LIMIT 5;
SELECT * FROM cd.facilities LIMIT 5;
SELECT * FROM cd.members LIMIT 5;
SELECT facid, SUM(slots) AS total_slots
FROM cd.bookings
WHERE starttime >= '2012-09-01' and starttime <= '2012-10-01'
GROUP BY facid
ORDER BY SUM(slots);
SELECT facid, SUM(slots) AS "total_slots"
FROM cd.bookings
GROUP BY facid
HAVING SUM(slots) > 1000
ORDER BY facid;
SELECT bookings.facid, name, starttime
FROM cd.facilities
JOIN name ON cd.boo
select bookings.starttime as start, facilities.name as name
from cd.facilities
join cd.bookings on facilities.facid = bookings.facid
where facilities.facid IN (0,1)
and bookings.starttime >= '2012-09-21'
and bookings.starttime < '2012-09-22'
order by bookings.starttime;
SELECT starttime as start, name
FROM cd.facilities
JOIN cd.bookings ON cd.facilities.facid = cd.bookings.facid
WHERE cd.facilities.facid IN (0,1)
AND starttime >= '2012-09-21'
AND starttime < '2012-09-22'
ORDER BY start;
SELECT starttime
FROM cd.members
JOIN cd.bookings ON members.memid = bookings.memid
WHERE members.firstname = 'David' AND members.surname = 'Farrell';
select bks.starttime from cd.bookings bks inner join cd.members mems on mems.memid = bks.memid where mems.firstname='David' and mems.surname='Farrell';