SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE IF NOT EXISTS Queries ( Id INTEGER, SiteId INTEGER, Query TEXT ); INSERT INTO Queries VALUES (1, 33, 'Query1'); DROP TABLE IF EXISTS SitePositions; CREATE TABLE SitePositions ( Id INTEGER, QueryId INTEGER, RegionCode INTEGER, Yandex INTEGER, Updated DATE ); INSERT INTO SitePositions (Id, QueryId, RegionCode, Yandex, Updated) VALUES (1, 1, 54, 1, '2021-05-20'); -- SELECT IIF(1 < 2, 'Yes', 'No' ) result; 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;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear