SELECT
    platform,vendor,brand,count(*)
FROM
    "public"."rawsupplierquotation"
WHERE
    "create_date" IS NOT NULL
    AND "price" IS NULL

GROUP BY platform,vendor,brand
ORDER BY
    count(*) desc