SELECT pr.Name, b.CheckIn, count(b.IdBooking) FROM tbooking b inner join tpackages ps on b.IdPackage = ps.IdPackages
Inner join tpackage p on ps.IdPackage = p.IdPackage
inner join tpackage_product pp on p.IdPackage = pp.IdPackage
inner join tproduct pr on pp.IdProduct = pr.IdProduct
where b.CheckIn between '2015-01-02' and '2015-02-06'
group by b.CheckIn