SELECT
    category,
    (date_upd::date) AS update_date,
    COUNT(name) AS name_cnt
FROM
    products_data_all
WHERE
    date_upd::date = '2019-06-05'
GROUP BY
    category,
    update_date
ORDER BY
    name_cnt