Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select labs.name as name, coalesce(labcounts.count, 0) as count, coalesce(totalcomputers.totalcount, 0) as totalcount from (select labs.name as name, count(*) as count from computers inner join rooms on (computers.room = rooms.id) inner join checkouts on (checkouts.computer = computers.id and checkouts.timein = checkouts.timeout) inner join patrons on (checkouts.patron = patrons.id) inner join labs on (rooms.lab = labs.id) group by labs.name) as labcounts right outer join labs on (labcounts.name = labs.name) left outer join (select labs.name, count(*) as totalcount from labs inner join rooms on (labs.id = rooms.lab) inner join computers on (rooms.id = computers.room) group by labs.name) as totalcomputers on (totalcomputers.name = labs.name)
Add Comment
Please, Sign In to add comment