如何在postgreSQL中获取按日期列分组的最大列数

CREATE TABLE my_table (
    date_column DATE,
    column_count INTEGER
);

INSERT INTO my_table (date_column, column_count) VALUES
    ('2022-01-01', 10),
    ('2022-01-01', 15),
    ('2022-01-02', 5),
    ('2022-01-02', 8),
    ('2022-01-02', 12);

SELECT date_column, MAX(column_count) AS max_column_count
FROM my_table
GROUP BY date_column;

SELECT date_column, MAX(column_count) AS max_column_count
FROM my_table
GROUP BY date_column
ORDER BY max_column_count DESC;