One package's downloads per day, user and CI

Custom SQL query (hide)

SELECT d.date, sum(CASE WHEN d.client_type = 'user' THEN d.request_count ELSE 0 END) AS user,
  sum(CASE WHEN d.client_type = 'ci' THEN d.request_count ELSE 0 END) AS ci
FROM dl_packages d JOIN dl_package_uuids u ON u.id = d.package_id JOIN registry_packages g ON g.uuid = u.uuid
WHERE g.name = :package GROUP BY d.date ORDER BY d.date

Query parameters

package

Edit SQL