Untitled

mail@pastecode.io avatar
unknown
plain_text
3 years ago
240 B
2
Indexable
Never
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;