sql coding

Question 2: Product table productNum name color price 1 pants blue 200 2 shirt White 150 3 shoes Blue 375 4 skirt Grey 250 5 belt Brown 300 6 short Grey 200 Sales table productNum num_of_items_sold 1 32 2 57 3 23 4 28 5 16 3- Write a query that returns the maximum price per color color max_price Blue 375 White 150 Grey 250 Brown 300