Gurux talabasi Qambaraliyev Ahliddin 2-deadline

611-21 gurux talabasi
Qambaraliyev Ahliddin
2-deadline

1. 
   Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha AND, OR, NOT operatorlaridan foydalanib so’rovlar yaratishi va natijasi bilan ko’rsatib o’tishi kerak.
   

mysql> use dengiz_axborot_tizimi;

Database changed
mysql> show tables;
+---------------------------------+
| Tables_in_dengiz_axborot_tizimi |
+---------------------------------+
| bazalar |
| kemalar |
| qismlar |
| shaxsiy_tarkib |
+---------------------------------+
4 rows in set (0.00 sec)

mysql> select * from kemalar;

+------------+-----------+---------------+------------+-----------+--------+-----------------+----------------+---------------+
| k_i_raqami | kema_nomi | kema_turi | y_sanasi | ish_vaqti | o_soni | v_qurilmasi | haydovchi_turi | joylashtirish |
+------------+-----------+---------------+------------+-----------+--------+-----------------+----------------+---------------+
| 1 | Arslon | Yuk tashuvchi | 2020-12-12 | 12:12:20 | 25 | yelkan | Tajribali | Kasbiy |
| 2 | Lochin | Kater | 2021-02-02 | 11:10:30 | 20 | Qutqaruv qayigi | Mutaxasis | Lablador |
| 3 | Bear | Kuryer | 2022-03-03 | 10:10:10 | 30 | Qayiqlar | Mutaxasis | Shimoliy |
+------------+-----------+---------------+------------+-----------+--------+-----------------+----------------+---------------+
3 rows in set (0.00 sec)

mysql> select* from kemalar where k_i_raqami='1' and joylashtirish='Kasbiy';

+------------+-----------+---------------+------------+-----------+--------+-------------+----------------+---------------+
| k_i_raqami | kema_nomi | kema_turi | y_sanasi | ish_vaqti | o_soni | v_qurilmasi | haydovchi_turi | joylashtirish |
+------------+-----------+---------------+------------+-----------+--------+-------------+----------------+---------------+
| 1 | Arslon | Yuk tashuvchi | 2020-12-12 | 12:12:20 | 25 | yelkan | Tajribali | Kasbiy |
+------------+-----------+---------------+------------+-----------+--------+-------------+----------------+---------------+
1 row in set (0.00 sec)

mysql> select* from kemalar where k_i_raqami='1' or joylashtirish='Kasbiy';

+------------+-----------+---------------+------------+-----------+--------+-------------+----------------+---------------+
| k_i_raqami | kema_nomi | kema_turi | y_sanasi | ish_vaqti | o_soni | v_qurilmasi | haydovchi_turi | joylashtirish |
+------------+-----------+---------------+------------+-----------+--------+-------------+----------------+---------------+
| 1 | Arslon | Yuk tashuvchi | 2020-12-12 | 12:12:20 | 25 | yelkan | Tajribali | Kasbiy |
+------------+-----------+---------------+------------+-----------+--------+-------------+----------------+---------------+
1 row in set (0.00 sec)

mysql> select* from kemalar where not( k_i_raqami='1' and joylashtirish='Kasbiy');

+------------+-----------+-----------+------------+-----------+--------+-----------------+----------------+---------------+
| k_i_raqami | kema_nomi | kema_turi | y_sanasi | ish_vaqti | o_soni | v_qurilmasi | haydovchi_turi | joylashtirish |
+------------+-----------+-----------+------------+-----------+--------+-----------------+----------------+---------------+
| 2 | Lochin | Kater | 2021-02-02 | 11:10:30 | 20 | Qutqaruv qayigi | Mutaxasis | Lablador |
| 3 | Bear | Kuryer | 2022-03-03 | 10:10:10 | 30 | Qayiqlar | Mutaxasis | Shimoliy |
+------------+-----------+-----------+------------+-----------+--------+-----------------+----------------+---------------+
2 rows in set (0.00 sec)

mysql>

2.