嗨，我有2个sql查询，我想在一个查询中运行它，以便解释查询第一个得到最常见的品牌名称
然后第二个获得最多的项目销售空品牌名称列
现在我想把两者结合起来，这样我就可以得到产品列表，其中它们有空的品牌名称列，但产品名称包含我拥有的品牌列表
这是我的第二个问题

select brand_name as top_brands
 from "catalog-my"."catalog_my_20210425" 
 where store_merchant_id like '%lazada%' and brand_name in ( 'HP'     ,'Acer','VAKIND','Casio','Lenovo','BF1 Soul',
                                                          'Sony','Lenovo','Samsung','Bosch','Xiaomi',
                                                       'Panasonic','Dell','Rondaful','Toshiba','UCUC',
                                                       'zanzea','CAMERON SINO','ZZOOI','Canon',
                                                      'Philips','LEGO','Glamorousky','ZeroQiQi','Baosity','Huawei'
                                                      ,'Alloet','Hontinga','OME','Jotun','Yamaha')
group by brand_name

第二个问题

SELECT name
,item_sold_30d
,brand_name
,category_name
,product_url
 FROM (
 SELECT DISTINCT b.name,b.item_sold_30d , b.brand_name ,b.category_name, a.product_url,                 ROW_NUMBER() OVER (PARTITION BY b.name,b.item_sold_30d , b.brand_name ,b.category_name ORDER BY  a.product_url) as rowId
 FROM "dasync"."outputs_lazada_my"a
  INNER JOIN "catalog-my"."catalog_my_20210425"b ON b.name = a.name
  WHERE b.name like '%'||brand_name||'%' and b.brand_name =''
  ORDER BY b.item_sold_30d DESC
   ) dt
  WHERE dt.rowId = 1
  limit 10;

请帮我把这两个组合起来