Get avg time on site by age ranges

Databases
1

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 ?

2

what happened when you tested it? ™

3

It actually works quite well
except I forgot

avg(timestampdiff(MINUTE,`A`.`access_start_datetime`,`A`.`access_end_datetime`)) AS `subfield`

sorry to bother you for this but being not very good at querielogy … :slight_smile: