Rank a Vendor by Price from a table with multiple SKUs and muliple Vendors in SQL 2000

select mp.*
, ( SELECT COUNT(*)
                 FROM merchant im
                 JOIN merchant_to_product imp
                   ON imp.fk_merchant_id = im.merchant_id
                  AND imp.fk_merchant_id <> 373
                WHERE im.is_active = 1
                  AND imp.sku = mp.sku
              ) other_merchant_count
from merchant_to_product mp
where mp.fk_merchant_id = 373
AND mp.price between 0 AND 300
AND mp.fk_subcategory_id = 89
AND mp.sku IN (SELECT imp.sku
                 FROM merchant im
                 JOIN merchant_to_product imp
                   ON imp.fk_merchant_id = im.merchant_id
                  AND imp.fk_merchant_id <> 373
                WHERE im.is_active = 1
              ) 
AND 5 <= ( SELECT COUNT(*)
                 FROM merchant im
                 JOIN merchant_to_product imp
                   ON imp.fk_merchant_id = im.merchant_id
                  AND imp.fk_merchant_id <> 373
                WHERE im.is_active = 1
                  AND imp.sku = mp.sku
              )