MS Access, How to find expensive coffee in a cafe?

Question

SQL

request:

SELECT Название, Цена FROM Напитки WHERE Код_группы = 6855

Answer 1

Sort by price, select the first line.
Your coffee is ready.

Answer 2

SELECT Название, Цена FROM Напитки WHERE Код_группы = 6855 ORDER BY Цена DESC LIMIT 1