mirror of
https://github.com/vladtrc/iw4L
synced 2026-10-26 02:11:39 -04:00
10 lines
185 B
SQL
10 lines
185 B
SQL
SELECT
|
|
ct.name,
|
|
COUNT(*) AS n,
|
|
AVG(c.value) AS avg_value,
|
|
MAX(c.value) AS max_value
|
|
FROM counter c
|
|
JOIN counter_track ct ON c.track_id = ct.id
|
|
GROUP BY ct.name
|
|
ORDER BY n DESC;
|