Sailor (SId, sname, Expertise, DateOfBirth) booking

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.
   

2. 
   Qizil rangdagi kemalar ni nomini chiqaring.
   
3. 
   Xar bitta exprtlik daraji nechta dengizchi bor.
   
4. 
   Xar bitta rangdan nechta qayiq bor.
   
5. 
   RED yoki GREEN ranglardagi kemalarda yurgan suzuvchilarni nomini toping.
   
6. 
   RED va Green kemalarda yurgan suzuvchilarni ismi va qodini toping.
   
7. 
   Bironda ham RED kemada yurmagan suzuvchini nomini va kodini toping.
   
8. 
   Eng kamida 2ta xarxil kemada yurgan suzuvchining nomini toping.
   
9. 
   Eng kamida 3ta xarxil kemada yurgan suzuvchining nomini toping.