E

SELECT monthDate,
       s.name as name,
       description,
       c.name as category_name,
       b.name as brand_name,
       sum_shows,
       sum_clicks,
       sum_orders,
       sum_gmv
FROM (SELECT DATE(strftime('%Y-%m-01', date)) as monthDate,
             name,
             description,
             category_id,
             brand_id,
             SUM(shows)                       as sum_shows,
             SUM(clicks)                      as sum_clicks,
             SUM(orders)                      as sum_orders,
             SUM(gmv)                         as sum_gmv
      FROM statistic
      WHERE shows >= clicks
        AND clicks >= orders
        AND date >= '2021-04-01'
        AND date <= '2021-07-31'
      GROUP BY monthDate, description, name, brand_id, category_id) s
         INNER JOIN (
    SELECT *
    FROM brands
    WHERE name <> 'Apple'
      AND name <> 'Samsung'
) b ON b.id = s.brand_id
         INNER JOIN (
    SELECT *
    FROM categories
    WHERE name <> 'Садовые измельчители'
      AND name <> 'Варочные панели'
) c ON c.id = s.category_id
ORDER BY monthDate ASC, sum_gmv DESC
LIMIT 100;