E

SELECT monthDate,
       s.name,
       description,
       c.name as category_name,
       b.name as brand_name,
       sum_shows,
       sum_clicks,
       sum_orders,
       sum_gmv
FROM (SELECT id,
             strftime('%m', 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 BETWEEN '2021-04-01' AND '2021-07-31'
      GROUP BY monthDate, name, brand_id, category_id, description) 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;