wiki:AdvancedReport19

Version 1 (modified by 211101, 5 days ago) ( diff )

--

Најчести времиња за трансакции

Во кој час од денот корисниците најчесто вршат трансакции

SELECT 
    EXTRACT(HOUR FROM t.date) AS transaction_hour, 
    COUNT(*) AS transaction_count
FROM 
    transaction t
GROUP BY 
    transaction_hour
ORDER BY 
    transaction_count DESC;
Note: See TracWiki for help on using the wiki.