io faccio una query del genere per vedere gli orari di punta delle telefonate in un call center, ma non capisco dove sbaglio :master:

codice:
SELECT count( CASE WHEN HOUR(dataeora) BETWEEN 9 AND 10 THEN 1 ELSE NULL ) AS a,
count( CASE WHEN HOUR(dataeora) BETWEEN 10 AND 11 THEN 1 ELSE NULL ) AS b,
count( CASE WHEN HOUR(dataeora) BETWEEN 11 AND 12 THEN 1 ELSE NULL ) AS c,
count( CASE WHEN HOUR(dataeora) BETWEEN 12 AND 13 THEN 1 ELSE NULL ) AS d,
count( CASE WHEN HOUR(dataeora) BETWEEN 13 AND 14 THEN 1 ELSE NULL ) AS e,
count( CASE WHEN HOUR(dataeora) BETWEEN 14 AND 15 THEN 1 ELSE NULL ) AS f,
count( CASE WHEN HOUR(dataeora) BETWEEN 15 AND 16 THEN 1 ELSE NULL ) AS g,
count( CASE WHEN HOUR(dataeora) BETWEEN 16 AND 17 THEN 1 ELSE NULL ) AS h,
count( CASE WHEN HOUR(dataeora) BETWEEN 17 AND 18 THEN 1 ELSE NULL ) AS i,
count( CASE WHEN HOUR(dataeora) BETWEEN 18 AND 19 THEN 1 ELSE NULL ) AS l,
count( CASE WHEN HOUR(dataeora) BETWEEN 19 AND 20 THEN 1 ELSE NULL ) AS m
FROM cc_inbound
ricevo un errore del genere:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS a,
count( CASE WHEN HOUR(dataeora) BETWEEN 10 AND 11 THEN

ho provato a cambiare ordine delle parentesi, metterne di più raggruppando il between, ma la sostanza non cambia.


qualcuno mi sa dire per cortesia dove sbaglio?







Grazie mille!