Hi,
query time this morning ^^
Is it right this query
SELECT A.domain_id AS domain_id,
CASE
WHEN FLOOR( (TO_DAYS( NOW( ) ) - TO_DAYS( U.nascita ) ) / 365.25) <18
THEN '13-17'
WHEN FLOOR( (TO_DAYS( NOW( ) ) - TO_DAYS( U.nascita ) ) / 365.25) >17 <25
THEN '18-24'
WHEN FLOOR( (TO_DAYS( NOW( ) ) - TO_DAYS( U.nascita ) ) / 365.25) >24 <35
THEN '25-34'
WHEN FLOOR( (TO_DAYS( NOW( ) ) - TO_DAYS( U.nascita ) ) / 365.25) >34 <45
THEN '35-44'
WHEN FLOOR( (TO_DAYS( NOW( ) ) - TO_DAYS( U.nascita ) ) / 365.25) >35 <55
THEN '45-54'
WHEN FLOOR( (TO_DAYS( NOW( ) ) - TO_DAYS( U.nascita ) ) / 365.25) >55 <65
THEN '55-64'
ELSE '65->'
END AS field,
NULL AS subfield,
CAST( A.access_start_datetime AS DATE ) AS DATE,
CASE
WHEN AVG( TIMESTAMPDIFF( MINUTE , A.access_start_datetime, A.access_end_datetime ) ) <10
THEN '0-10'
WHEN AVG( TIMESTAMPDIFF( MINUTE , A.access_start_datetime, A.access_end_datetime ) ) >11 <21
THEN '10-20'
WHEN AVG( TIMESTAMPDIFF( MINUTE , A.access_start_datetime, A.access_end_datetime ) ) >21 <31
THEN '20-30'
ELSE '30+'
END AS value
FROM stats_access A
JOIN users U ON U.id = A.fb_id
WHERE (A.fb_id IS NOT NULL)
GROUP BY A.domain_id, field, CAST( A.access_start_datetime AS DATE )
to get the avg time on site by age ranges ?