Untitled

SELECT carmake, carmodel, carlistprice AS "Highest List Price"
FROM (SELECT carmake, carmodel, carlistprice, ROW_NUMBER() OVER(PARTITION BY carmake ORDER BY carlistprice desc) AS row_number
     FROM si.car
     WHERE carlistprice IS NOT NULL) 
WHERE row_number = 1;