| Version 1 (modified by , 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.
