julia

CREATE TABLE SklC0 (
    SELECT Nr, HOUR, COUNTRY_NAME, REGION_NAME, CITY_NAME, PLACE, USER_ID
    FROM (
        SELECT * FROM $tab1 WHERE (
        PRODUCT_ID= $p_id AND PLACE='c')
    )
);

SELECT HOUR, COUNTRY_NAME, REGION_NAME, CITY_NAME, COUNT(Nr) AS PRODUCTS_SOLD, COUNT(DISTINCT USER_ID) AS CUSTOMERS
    FROM SklC0
    GROUP BY CITY_NAME
    ORDER BY HOUR
    LIMIT 0, 60;