julia2

SELECT HOUR, COUNTRY_NAME, REGION_NAME, CITY_NAME, COUNT(Nr) AS PRODUCTS_SOLD, COUNT(DISTINCT USER_ID) AS CUSTOMERS
    FROM SklC0
    WHERE HOUR='2009-06-14 19:00:00'
    GROUP BY CITY_NAME;