MYSQL条件查询、分组查询

SELECT
	securityno,
	(
		SELECT
			NAME
		FROM
			drugstore_sales_atc
		WHERE
			atc = securityno
	) atc_name,
sum(productqty) s_productqty,
	sum(realmoney) s_money

FROM
	drugstore_sales_consume_quantity_top5_150000_2024
WHERE
	securityno IS NOT NULL
AND securityno NOT LIKE '00%'
AND securityno NOT LIKE 'Q%'
AND securityno NOT LIKE 'T%'
AND securityno REGEXP '[^0-9]' = 1
AND date >= '2024-01-01'
AND date <= '2024-03-29'
GROUP BY
	securityno
ORDER BY
	s_productqty DESC;

SELECT
	securityno,
	(
		SELECT
			productname
		FROM
			drugstore_nmg.com_product
		WHERE
			securityno = a.securityno
		AND rownum = 1
	),
	sum(to_number(realmoney)) s_qty
FROM
	drugstore_nmg.rtp_retaildetail a
WHERE
	useday >= to_date ('2024-02-28', 'yyyy-MM-dd')
AND securityno NOT LIKE 'T%'
AND securityno NOT LIKE '0%'
GROUP BY
	securityno
ORDER BY
	s_qty DESC