SELECT
CONCAT(period.`from`, '-', period.`to`) as period_,
count(s.`start`),
sum(ifnull(s.price, 0))
FROM seans s
JOIN bilet b ON s.id = b.seans_id
RIGHT JOIN
(
    SELECT 9 as `from`, 14 as `to`
    UNION
    SELECT 15, 17
    UNION
    SELECT 18, 20
    UNION
    SELECT 21, 23) as period
ON (hour(s.start) BETWEEN period.`from` AND period.`to`)
GROUP BY period_
ORDER BY period.`from`, period.`to`