Downloads Postgres Utility Sql

List release sets by release date

SELECT
    family_id,
    family_name,
    release_date
FROM
    release_set_normalized
GROUP BY
    family_id,
    family_name,
    release_date
ORDER BY
    family_name,
    release_date DESC

SELECT
    family_id,
    family_name,
    release_date,
    family_availability
FROM
    release_set_normalized
GROUP BY
    family_availability,
    family_id,
    family_name,
    release_date
ORDER BY
    family_name,
    release_date DESC