Select *from umumiy where fish=’Aliyev Vali’ and manzil=’Buxoro’

SELECT id
FROM talaba
WHERE yosh > 20 OR staj > 5;
2.
SELECT *
FROM talaba
WHERE standard = 0 AND (yosh > 20 OR staj>5);
3.
SELECT *
FROM talaba
WHERE (name LIKE 'C%' OR name LIKE 'W%')

TOPHIRIQLAR
1.Select va from kalit so’zlaridan foydalanib yaratgan talaba nomli jadvalingizni chop eting.
2.Yaratgan talaba nomli jadvalingizdan FISH nomi ustunini ISM nomiga almashtirib chop eting.
3. DISTINCT operatoridan foydalanib, takrorlanuvchi FISHlardan faqat bittadan nomini qoldiring.
4.Where operatoridan foydalanib so’rov yarating.
5.Order by operatoridan foydalanib so’rov yarating.
6.AND operatoridan foydalanib so’rov yarating.
7.OR operatoridan foydalanib so’rov yarating.
8. NOT operatoridan foydalanib so’rov yarating.
9.IN operatoridan foydalanib so’rov yarating/
10.NOT operatoridan foydalanib so’rov yarating.
11.LIKE operatoridan foydalanib so’rov yarating.
12.NOT LIKE operatoridan foydalanib so’rov yarating.
13.LIKE operatoridan foydalanib, ismingizni bosh harfi bilan boshlanadigan talabalarni chop eting.
14. BETWEEN operatoridan foydalanib, ismingizni bosh harfi bilan boshlanadigan talabalarni chop eting.
15.IS NULL operatoridan foydalanib, ismingizni bosh harfi bilan boshlanadigan talabalarni chop eting.