1.

SELECT vardas, pavarde, miestas FROM klientai ORDER BY pavarde ASC;

2.

SELECT vardas, pavarde, miestas FROM klientai ORDER BY pavarde DESC;

3.

SELECT * FROM uzsakymu_sarasas WHERE kaina > 10.00 ORDER BY kaina ASC;