-- Get building code, room number, and cap for rooms that have a DVD
--
SELECT room.bcode, room.rnumber, cap
FROM   room, roommedia
WHERE  mcode = 'DVD' and
       room.bcode = roommedia.bcode and
       room.rnumber = roommedia.rnumber

-- Get building code, room number, and cap for rooms that have a DVD
-- and have a cap > 100
SELECT room.bcode, room.rnumber, cap
FROM   room, roommedia
WHERE  mcode = 'DVD' and
       cap > 100 and
       room.bcode = roommedia.bcode and
       room.rnumber = roommedia.rnumber