SELECT
	*,
		(
			SELECT
				ji_quata_4.changerate
			FROM
				ji_quata_4
			WHERE
				ji_quata_4.stock_code = a.stock_code
		
	) changra
FROM
	(
		SELECT
			*, sum(count) sc,
			(
				SELECT
					count
				FROM
					ji_stock_action_result ar
				WHERE
					ar.stock_code = ji_stock_action_result.stock_code
				AND ar.date = '2020-09-30'
			) newc,
			(
				SELECT
					count
				FROM
					ji_stock_action_result ar
				WHERE
					ar.stock_code = ji_stock_action_result.stock_code
				AND ar.date = '2020-09-30'
			) / sum(count) AS rs
		FROM
			ji_stock_action_result
		GROUP BY
			stock_code
		ORDER BY
			date DESC,
			rs DESC
	) a
WHERE
rs>0.6
and
	sc BETWEEN 100 and 300
ORDER BY
	rs DESC

42279	002459	晶澳科技	1	新增	2020-03-31	0	0	1	114	97	0.8509	14.96
46609	601966	玲珑轮胎	20	增持	2019-12-31	4	8	28	185	148	0.8000	
44131	300274	阳光电源	-6	减持	2019-12-31	0	9	3	113	85	0.7522	162.93
41716	002049	紫光国微	12	新增	2019-12-31	3	7	19	103	74	0.7184	12.65
45772	600660	福耀玻璃	46	增持	2019-12-31	4	15	61	181	128	0.7072	48.35
46443	601633	长城汽车	33	新增	2019-12-31	0	0	33	203	136	0.6700	97.75
42619	002709	天赐材料	7	新增	2019-12-31	8	1	8	185	123	0.6649	100.77
42434	002594	比亚迪	-1	减持	2019-12-31	1	15	14	291	177	0.6082	67.15
42901	002938	鹏鼎控股	15	新增	2019-12-31	2	13	28	209	126	0.6029	-13.15