Получение вычисляемого числа строк

SELECT *
FROM SALES_BY_SHOPS_WEEKLY AS sbs 
LEFT JOIN SHOPS_COUNT_WEEKLY AS sc 
ON (sbs.GROUP=sc.GROUP) AND (sbs.WEEK=sc.WEEK)

WHERE 
(SELECT count(*) FROM SALES_BY_SHOPS_WEEKLY AS sbs2 
 WHERE sbs2.SOLD > sbs.SOLD AND sbs2.WEEK = 
 sbs.WEEK AND sbs2.GROUP = sbs.GROUP
) < sc.SHOPS_COUNT * 15/100;