Untitled

 avatar
unknown
plain_text
a year ago
268 B
4
Indexable
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; 
Editor is loading...
Leave a Comment