SELECT CASE nota
WHEN 1 THEN 'Péssimo'
WHEN 2 THEN 'Ruim'
WHEN 3 THEN 'Bom'
WHEN 4 THEN 'Ótimo'
ELSE 'Excelente' END AS categoria_hospedagens,
COUNT(*) as qtd_hospedagens
FROM avaliacoes
GROUP BY categoria_hospedagens
ORDER BY nota DESC;
