How to combine multiple requests into one?

Question

SQLite

There is a database with positions of search requests. Now we have to write a separate request for each of the cities and get the necessary data. Request example:

SELECT Query AS "Ключевая фраза",
   SUM(CASE Updated WHEN '2021-05-20'  THEN Yandex ELSE 0 END) AS "Я 2021-05-20 Екб"
 
FROM Queries c LEFT JOIN
   SitePositions o ON c.Id = o.QueryId
   WHERE SiteId = 33 AND RegionCode = 54
GROUP BY QueryId

The essence is in RegionCode. For example, for Yekaterinburg it can be 54. Relatively speaking, for Voronezh - 193. What is the result:


For Voronezh, the following query is used:

SELECT Query AS "Ключевая фраза",
   SUM(CASE Updated WHEN '2021-05-20'  THEN Yandex ELSE 0 END) AS "Я 2021-05-20 Воронеж"
 
FROM Queries c LEFT JOIN
   SitePositions o ON c.Id = o.QueryId
   WHERE SiteId = 33 AND RegionCode = 193
GROUP BY QueryId

How should I complete the query to combine these two queries into 1? The expected result is something like this:


The structure of the Queries and SitePosition tables is as follows, respectively:

Answer 1

SELECT 
  Query AS "Ключевая фраза",
  SUM(CASE WHEN (Updated = '2021-05-20' AND RegionCode = 54) THEN Yandex ELSE 0 END) AS "Yandex ekb",
  SUM(CASE WHEN (Updated = '2021-05-20' AND RegionCode = 193) THEN Yandex ELSE 0 END) AS "Yandex vor"
FROM Queries c 
LEFT JOIN SitePositions o ON c.Id = o.QueryId
WHERE SiteId = 33
GROUP BY QueryId, Query;

SQLite fiddle