3.6.3. Maximum of Column per Group

Task: Find the highest price per article.

SELECT article, MAX(price) AS priceFROM   shopGROUP BY article;+---------+-------+| article | price |+---------+-------+|    0001 |  3.99 ||    0002 | 10.99 ||    0003 |  1.69 ||    0004 | 19.95 |+---------+-------+