[MySQL] Group by su condizione complessa

[123delphi321]

hai provato cosi:

select sum(valore),
case(1) 
	WHEN (orario>='09.00.00' and orario<'10.00.00') THEN 'fascia1'
	WHEN (orario>='10.00.00' and orario<'11.00.00') THEN 'fascia2'
	ELSE NULL END 
	as fascia_oraria
from tabella1
where (orario>='09.00.00' and orario<'10.00.00') or (orario>='10.00.00' and orario<'11.00.00')
group by 
case(1) 
	WHEN (orario>='09.00.00' and orario<'10.00.00') THEN 'fascia1'
	WHEN (orario>='10.00.00' and orario<'11.00.00') THEN 'fascia2'
	ELSE  NULL  END

ciao