select banner_id as banner,
	(select count(ah_type) from advertisement_hits where ah_type='view' and banner_id = banner) as views,
	(select count(ah_type) as clicks from advertisement_hits where ah_type='click' and banner_id = banner) as clicks
from advertisement_hits group by banner;