N. B. The Surface is expressed in square meters. For contracts that have not yet expired the EndDate is null

SQL Misolcha 5

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

FLAT (FCode, Address, City, Surface)
LEASING CONTRACT (LCCode, StartDate, EndDate, PersonName, MonthlyPrice, FCode)
N.B. The Surface is expressed in square meters. For contracts that have not yet expired the EndDate is NULL

1.Eng Kamida 3 kontract bor bo’lgan shaxarlar uchun quyidagilarni toping: shaxar nomi, eng kata oylik to’lov, o’rtacha oylik to’lov, eng kata leasing kontractni davomligi, o’rtacha leasing contract davomligi, kelishilgan kontractlarning umumit soni

2. Faqat 80 m^2 dan kata bo’lmagan kvartira arenda olgan odamlarning ismini toping. (barchasi 80 dan kichik)
3. Bitta kvartiraga 2ta kontract dan ortiq contract tuzgan odamni ismini toping.
4. Oylik arenda puli hardoim 500$ dan katta bo’lgan, 5ta kantraktan ko’p kantrakt tuzilgan va Turin shaxrida joylashgan kvartiralarni kode va adresini toping.