FROM Model SELECT Name GROUP BY Name HAVING MAX(Price) > 100 AND Name > 'B'.

SELECT Name GROUP BY Name FROM Model HAVING MAX(Price) > 100 AND Name > 'B'

SELECT Name FROM Model HAVING MAX(Price) > 100 AND Name > 'B' GROUP BY Name.

SELECT Name FROM Model GROUP BY Name HAVING MAX(Price) > 100 AND Name > 'B'