9. Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha JOIN
operatorilaridan foydalanib so’rovlar yaratishi va natijasi bilan ko’rsatib
o’tishi kerak.
mysql> SELECT mashinalar.mashina_id, qismlar.qism_nomi, mashinalar.javobgar_xodim
FROM mashinalar
INNER JOIN qismlar ON mashinalar.mashina_id=qismlar.qism_id;
+------------+------------------+-------------------+
| mashina_id | qism_nomi | javobgar_xodim |
+------------+------------------+-------------------+
| 1 | Boshlangich | Behruz Keldiyev |
| 2 | Kattalar | Behruz Keldiyev |
| 3 | Boshlangich | Abduvohid Komilov |
| 4 | Boshlangich | Abduvohid Komilov |
+------------+------------------+-------------------+
4 rows in set (0.00 sec)
