Products from two warehouses
Products from two warehouses
The tovary table of the "Kotomarket" marketplace stores products and the cities where their warehouses are located.
A manager wants to see products stored in a warehouse in Moscow or in Saint Petersburg — to plan delivery across the two capitals.
Return the columns id, nazvanie, gorod_sklada, cena for products whose gorod_sklada equals 'Москва' or 'Санкт-Петербург'.
Row order does not matter.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.
| id | nazvanie | gorod_sklada | cena |
|---|---|---|---|
| 1 | Когтеточка "Башня" | Москва | 2400 |
| 3 | Игрушка-мышка | Санкт-Петербург | 150 |
| 5 | Шлейка для кота | Москва | 600 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid