SQL topshirig'larining 5.3 darajasi
Berilgan jadvallar:
| id | first_name | last_name | date_of_birth |
|---|---|---|---|
| 1 | John | Smith | 1987-12-12 |
| 2 | Alex | Cooper | 1999-02-20 |
| 3 | Agata | Leyla | 1970-01-30 |
| 4 | Ivan | Ivanov | 1994-05-31 |
| 5 | Peter | Petrov | 1991-08-24 |
| id | title | body | author_id |
|---|---|---|---|
| 1 | Post-1 | Lorem ipsum dolor sit amet, consectetur adipiscing elit. | 12 |
| 2 | Post-2 | Duis aute irure dolor in reprehenderit in voluptate. | 24 |
| 3 | Post-3 | Sed ut perspiciatis, unde omnis iste natus error. | 2 |
| 4 | Post-4 | Ut enim ad minima veniam, quis nostrum. | 1 |
| 5 | Post-5 | Quis autem vel eum iure reprehenderit. | 34 |
| 6 | Post-6 | Et harum quidem rerum facilis est et expedita. | 31 |
| 7 | Post-7 | Excepteur sint occaecat cupidatat. | 22 |
| 8 | Post-8 | Ullam corporis suscipit laboriosam, nisi ut aliquid. | 11 |
Ularni quyidagi topshiriqlarni yeching:
Postlarning va ularning mualliflarining to'liq ro'yxatini oling, hatto postning muallifi bo'lmasa ham.
Mualliflarning va ularning postlarining to'liq ro'yxatini oling, hatto muallifning bitta posti bo'lmasa ham.
Mualliflarning ismlari va tug'ilgan yilini va ular yozgan post nomini oling. E'tibor bering, muallif bitta post yozmagan bo'lishi mumkin.
Mualliflarning ismlari va ularning postlarini oling. Bunda, bitta posti bo'lmagan barcha mualliflar uchun.
