1-laboratoriya topshirig’i

SELECT t.Name,t.Composer,a.Title

FROM Album as a

JOIN Track as t

ON t.AlbumId=a.AlbumId

WHERE t.Name LIKE 'A%' AND t.Composer IS NOT NULL ;

Bu so’rovda JOIN buyrug’ini ishlatamiz, chunki bitta emas, ikkita jadvaldan bir vaqtning o’zida foydalanishimiz lozim. Album jadvalini a deb, Track jadvalini t deb olamiz va kerakli so’rovni yozamiz.

4) ushbu savolda bitta invoice da eng ko'p pul sarflagan eng yaxshi o'nta xaridorlar uchun promotional Music Festivak o'tkazmoqchi. Invoice umumiy kamayishi bo'yicha buyurtma qilingan eng yaxshi 10 ta invoice uchun ism, familiya va invoice summasini qaytaradigan so'rov yozish lozim.