SELECT asl.type as тип, asl.year as год, asl.price as стоимость FROM asl!asl WHERE asl.price = (select max(asl.price) FROM asl!asl WHERE asl.type=asl.type)

set safety off
SELECT MIN(Asl.price), MAX(Asl.price), AVG(Asl.price);
 FROM ;
     asl!asl;
 GROUP BY Asl.type;
 INTO TABLE query4.dbf  
set safety on

SELECT Asl.type AS тип, Query4.max_price,;
  Asl.price AS стоимость;
 FROM ;
     asl!asl