Untitled

SELECT 
    (date_upd::date = '2019-06-05') as  update_date,
    category,
	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;