How to make a request for a non-standard selection of data from 3 tables?

Question

SQL

How to select data from tables to get something like in the picture.

Answer 1

At the database level, such gluing can be done only if it is known in advance which warehouses to look for (To do this, a sequential JOIN of the same table with different sklad_id is done), or if the product for which such a selection is built is known in advance (select for all warehouses by product id, then PIVOT selections).
For a spherical horse in a vacuum, in my opinion, only pandemonium at the application level is suitable.

Answer 2

1) JOIN three tables example
2) Excel pivot table pivot table example example