sql join and in statement

select count(*) from consumption_beta where load_id in
(
 select load_id from electricity_load where load_id in
(
 select load_id from meterandset where set_id in
(
 select set_id from meter_set where building_id in
(
 select building_id from building where campus_id = 8
)
)
)
)


select count(*) from consumption_beta as c
left join electricity_load as e on c.load_id = e.load_id
where e.load_id in
(
 select load_id from meterandset where set_id in
(
 select set_id from meter_set where building_id in
(
 select building_id from building where campus_id = 8
)
)
)


select count(*) from consumption_beta as c
left join electricity_load as e on c.load_id = e.load_id
where e.load_id in
(
 select m.load_id from meterandset as m
 left join meter_set as ms on m.set_id = ms.set_id
 where ms.building_id in
(
 select building_id from building where campus_id = 8
)
)

select count(*) from consumption_beta as c
left join electricity_load as e on c.load_id = e.load_id
where e.load_id in
(
 select m.load_id from meterandset as m
 left join meter_set as ms on m.set_id = ms.set_id
 left join building as b on ms.building_id = b.building_id
 where b.campus_id = 8
)

select c.load_id,reading_timestamp,get_consumption from consumption_beta as c
left join electricity_load as e on c.load_id = e.load_id
where e.load_id in
(
 select m.load_id from meterandset as m
 left join meter_set as ms on m.set_id = ms.set_id
 left join building as b on ms.building_id = b.building_id
 where b.campus_id = 8
)
and reading_timestamp < '2006-09-30 22:00:00+08' and reading_timestamp > '2006-01-01 0:0:0+0'