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;