SELECT
q3.stock_name,
	ji_stock_price_mon.stock_code,
	ji_stock_price_mon.price,
	(spre.price - tpre.price) a,
	(spre.price - tpre.price) / tpre.price * 100 AS arate,
	(pre.price - spre.price) b,
	(pre.price - spre.price) / spre.price * 100 AS brate,

	(
		ji_stock_price_mon.price - pre.price
	) c,
	(
		ji_stock_price_mon.price - pre.price
	) / pre.price * 100 AS crate,
	(
		ji_stock_price_mon.price - pre.price
	) c,
	(pre.price - spre.price) / spre.price * 100 - ((spre.price - tpre.price) / tpre.price * 100) as b_a,
	(
		ji_stock_price_mon.price - pre.price
	) / pre.price * 100 - ((pre.price - spre.price) / spre.price * 100) as c_b,
((ji_stock_price_mon.price - pre.price) / pre.price * 100 - ((pre.price - spre.price) / spre.price * 100) - ((pre.price - spre.price) / spre.price * 100 - ((spre.price - tpre.price) / tpre.price * 100)))/ ((pre.price - spre.price) / spre.price * 100 - ((spre.price - tpre.price) / tpre.price * 100))*100 plusrate
FROM
	ji_stock_price_mon
JOIN ji_stock_price_mon pre ON pre.stock_code = ji_stock_price_mon.stock_code
AND pre.mon = 620
JOIN ji_stock_price_mon spre ON spre.stock_code = pre.stock_code
AND spre.mon = 619
JOIN ji_stock_price_mon tpre ON tpre.stock_code = spre.stock_code
JOIN ji_quata_3 q3 ON q3.stock_code = spre.stock_code
AND tpre.mon = 618
WHERE
	ji_stock_price_mon.mon = 621
AND pre.price - spre.price > 0
AND ji_stock_price_mon.price - pre.price > 0
AND (
	ji_stock_price_mon.price - pre.price
) > (pre.price - spre.price)
-- AND (spre.price - tpre.price) / tpre.price * 100 < 10
-- AND (pre.price - spre.price) / spre.price * 100 < 10
AND (
	ji_stock_price_mon.price - pre.price
) / pre.price * 100 > 10
AND ji_stock_price_mon.stock_code NOT LIKE '688%'
AND ji_stock_price_mon.stock_code NOT LIKE '300%'
AND (
		ji_stock_price_mon.price - pre.price
	) / pre.price * 100 - ((pre.price - spre.price) / spre.price * 100) - ((pre.price - spre.price) / spre.price * 100 - ((spre.price - tpre.price) / tpre.price * 100))>0

ORDER BY 
((ji_stock_price_mon.price - pre.price) / pre.price * 100 - ((pre.price - spre.price) / spre.price * 100) - ((pre.price - spre.price) / spre.price * 100 - ((spre.price - tpre.price) / tpre.price * 100)))/ ((pre.price - spre.price) / spre.price * 100 - ((spre.price - tpre.price) / tpre.price * 100)) desc