Sailor (SId, sname, Expertise, DateOfBirth) booking


Download 15.92 Kb.
Sana07.05.2023
Hajmi15.92 Kb.
#1439492
Bog'liq
exercise 2


SQL Misolcha 2

Quyidagi table lar berilgan. Table malumotlarini bazadan ko’rishingiz mumkin.



SAILOR (SId, SName, Expertise, DateOfBirth)
BOOKING (SId, BId, Date)
BOAT (BId, BName, Color)

Sailor – dengizchi, Odamga nisbatan aytiladi. Dengizchi papay multikudagi dengizchi persanaji


Booking – buyurtma
Boat – qayiq
Expertise – tajriba,



  1. Expertlik darajasi HIGH bo’lgan dengizchi laring sonin toping.



  1. Qizil rangdagi kemalar ni nomini chiqaring.

  2. Xar bitta exprtlik daraji nechta dengizchi bor.

  3. Xar bitta rangdan nechta qayiq bor.

  4. RED yoki GREEN ranglardagi kemalarda yurgan suzuvchilarni nomini toping.

  5. RED va Green kemalarda yurgan suzuvchilarni ismi va qodini toping.

  6. Bironda ham RED kemada yurmagan suzuvchini nomini va kodini toping.

  7. Eng kamida 2ta xarxil kemada yurgan suzuvchining nomini toping.

  8. Eng kamida 3ta xarxil kemada yurgan suzuvchining nomini toping.

Download 15.92 Kb.

Do'stlaringiz bilan baham:




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling