Avtomabile’ nomli jadvalimiz 712. 20-guruh Boltaboyev Doniyor

‘avtomabile’ nomli jadvalimiz
712.20-guruh
Boltaboyev Doniyor
(max,min,group by, order by, beetwen)shartlarining ishlashi

SELECT MIN(Motor) AS SmallestMotor

FROM avtomabile;

SELECT MAX(Motor) AS LargestMotor
FROM avtomabile;


SELECT * FROM avtomabile
WHERE ID BETWEEN 2 AND 3;


SELECT COUNT(ID), Name
FROM avtomabile
GROUP BY Name;


SELECT * FROM avtomabile
ORDER BY Name;