Resolved: Find max of a column and its category

Date          Category     quantity
2022-04-15    A            500
2022-04-15    B            700
2022-04-15    F            900
2022-04-16    M            400

Date          Category     quantity
2022-04-15    F            900
2022-04-16    M            400

SELECT Date, max(quantity)
FROM table
GROUP BY Date

SELECT Date, Category, quantity
FROM yourTable
WHERE 1 = 1
QUALIFY ROW_NUMBER() OVER (PARTITION BY Date ORDER BY quantity DESC) = 1;