SELECT COUNTRY.NAME_CTR, CITY.NAME_C, ISNULL(COUNT(DISTINCT(TOURIST.ID_TRT)), 0) FROM COUNTRY INNER JOIN CITY
ON COUNTRY.ID_CTR = CITY.ID_CTR LEFT JOIN HOTEL
ON CITY.ID_CTY = HOTEL.ID_CTY INNER JOIN TOUR
ON HOTEL.ID_H = TOUR.ID_H LEFT JOIN TOURIST
ON TOUR.ID_TRT = TOURIST.ID_TRT LEFT JOIN TYPE_B
ON HOTEL.ID_TB = TYPE_B.ID_TB
WHERE TYPE_B.NAME_TB='BB' OR TYPE_B.NAME_TB='FB' OR TYPE_B.NAME_TB IS NULL
GROUP BY COUNTRY.NAME_CTR, CITY.NAME_C
HAVING COUNT(DISTINCT(TOURIST.ID_TRT)) < 2