WITH BASE_SALE AS(
	SELECT
		C.PF_CODE,
		C.TOTAL_VALUE AS SALE_MONEY
	FROM
		CONVENIENCE C
	WHERE
		C.SURVEY_YEAR = 2019
	AND C.KIND_CODE = '100'
),
BASE_STORE AS(
	SELECT
		C.PF_CODE,
		C.TOTAL_VALUE AS STORE_CNT
	FROM
		CONVENIENCE C
	WHERE
		C.SURVEY_YEAR = 2019
	AND C.KIND_CODE = '150'
),
BASE_TABLE AS(
	SELECT
		ROW_NUMBER() OVER (ORDER BY S.SALE_MONEY DESC, T.STORE_CNT ASC) AS RNUM,
		S.PF_CODE,
		SALE_MONEY,
		STORE_CNT
	FROM
		BASE_SALE S
		INNER JOIN BASE_STORE T
		ON S.PF_CODE = T.PF_CODE
	ORDER BY
		RNUM
)
SELECT * FROM BASE_TABLE