VOC

SELECT
'Japan' COUNTRY_CODE
, HHM.REGION_CODE
, BRC.REGION_NAME_EN AS REGION_NAME
, HHM.HOTEL_CODE
, HHM.HOTEL_NAME_EN AS HOTEL_NAME
, BBHI.BOOKING_ITEM_CODE AS BOOKING_CODE
, BBHI.CHECK_IN_DATE
, BBHI.CHECK_OUT_DATE
, BBHI.FIRST_INSERT_DATETIME BOOKING_DATETIME
, CASE WHEN BBHI.BOOKING_STATUS_CODE IN ('BKS02', 'BKS05') THEN 'Confirmed' ELSE 'Cancelled' END AS STATUS
FROM BK_BOOKING_HOTEL_ITEM BBHI
INNER JOIN BK_BOOKING_MASTER BBM ON BBHI.BOOKING_CODE = BBM.BOOKING_CODE
INNER JOIN HO_HOTEL_MASTER HHM ON BBHI.HOTEL_CODE = HHM.HOTEL_CODE AND HHM.COUNTRY_CODE = 'JP'
INNER JOIN BS_REGION_CODE BRC ON BRC.REGION_CODE = HHM.REGION_CODE
WHERE YEAR = 2025 AND MONTH IN (7, 8)
AND (BRC.REGION_CODE = 116548 OR BRC.PARENT_REGION_CODE = 116548)
ORDER BY BBHI.FIRST_INSERT_DATETIME

;
/*
Okinawa City: 143759
Naha: 102120
Onna: 116547
Ishigaki: 101232
Miyakojima: 101872
Nago: 116546
Yomitan: 116548
Chatan: 186676
Okinawa: 139953

*/