SQLize | PHPize | SQLtest

ТАБЛИЦА SHOPS SHOP DOC_NUMBER DAY SHIPMENT 1220 1123-4553-08 27.12.2021 COU 1221 0811-4553-08 24.11.2021 PNT 1222 0043-4553-14 25.12.2021 LCTN 1320 2333-4553-16 20.10.2021 PNT 1330 1000-4553-10 27.12.2021 COU 1450 0999-4553-14 26.09.2021 PNT 1520 1499-4553-08 22.12.2021 COU ТАБЛИЦА WAREHOUSE WAREHOUSE ID DOCUMENT MONTH 11231521 0 08111221 0 00431022 0 23331320 0 10001330 0 09991450 0 14991520 0 Необходимые преобразования: WITH T1 AS (SELECT SHOPS.SHOP FROM SHOPS JOIN WAREHOUSE ON SUBSTRING(WAREHOUSE.ID, 5, 4) = SHOPS.SHOP) UPDATE WAREHOUSE SET WAREHOUSE = CASE WHEN WAREHOUSE.WAREHOUSE = '' AND SUBSTRING(WAREHOUSE.ID, 5, 4) IN (SELECT SHOP FROM T1) THEN (SELECT SUBSTRING(SHOPS.DOC_NUMBER, 11, 2) FROM SHOPS WHERE SUBSTRING(WAREHOUSE.ID, 5, 4) = SHOPS.SHOP) END, DOCUMENT = CASE WHEN WAREHOUSE.DOCUMENT = '' AND SUBSTRING(WAREHOUSE.ID, 5, 4) IN (SELECT SHOP FROM T1) THEN (SELECT (SUBSTRING(SHOPS.DOC_NUMBER, 6, 7) + '-' + SUBSTRING(CAST(SHOPS.DAY AS CHAR), 6, 5)) FROMSHOPS WHERE SUBSTRING(WAREHOUSE.ID, 5, 4) = SHOPS.SHOP) END, MONTH = CASE WHEN WAREHOUSE.MONTH = 0 AND SUBSTRING(WAREHOUSE.ID, 5, 4) IN (SELECT SHOP FROM T1) THEN (SELECT (SUBSTRING(CAST(SHOPS.DAY AS CHAR), 6, 2)) FROM SHOPS WHERE SUBSTRING(WAREHOUSE.ID, 5, 4)= SHOPS.SHOP) END Вопрос: Какое значение вернет sql скрипт? SELECT COUNT(WAREHOUSE) FROM WAREHOUSE WHERE WAREHOUSE IS NOT NULL AND SUBSTRING(WAREHOUSE.DOCUMENT, 12, 2) >= 24;