Сделать вывод из БД с сортировкой

    SELECT B.brand_id,COUNT(*) COUNT FROM buy_products A
    LEFT JOIN table_produkts B
    ON B.products_id = A.buy_id_product
    GROUP BY B.brand_id

CREATE TABLE
table_produkts (
  products_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  products_name TEXT NOT NULL,
  brand_id INT UNSIGNED NOT NULL,
  PRIMARY KEY(products_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
 
CREATE TABLE
orders (
  order_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  order_name TEXT NOT NULL,
  PRIMARY KEY(order_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
 
CREATE TABLE
buy_products (
  buy_id_product INT UNSIGNED NOT NULL,
  buy_id_orders INT UNSIGNED NOT NULL,
  order_pay TINYINT(1) NOT NULL,
  FOREIGN KEY (buy_id_product) REFERENCES table_produkts(products_id) ON DELETE CASCADE,
  FOREIGN KEY (buy_id_orders) REFERENCES orders(order_id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
 
-- получение кол-ва купленных товаров по категориям
SELECT B.brand_id, COUNT(*) COUNT FROM buy_products A
LEFT JOIN table_produkts B
ON B.products_id = A.buy_id_product
WHERE A.order_pay = 1
GROUP BY B.brand_id

SELECT C.brand_id,SUM(B.buy_count_product) count_products FROM orders A
LEFT JOIN buy_products B
ON B.buy_id_orders = A.order_id
LEFT JOIN table_produkts C
ON C.products_id = B.buy_id_product
WHERE A.order_pay = 'оплачено'
GROUP BY C.brand_id