title: combine 2 query statements into one
body: <p>hi I have 2 sql query and I would like to run it in one query
  so to explain about the query the first one to get the most frequent brand names</p>
  <p>then the second one to get the most item sold with empty brand name column</p>
  <p>now I want to combine both so I can get the list of products where they have empty brand name column but the name of product contains the list of brands I have</p>
  <p>here is my 2 query</p>
  <pre><code>select brand_name as top_brands
   from &quot;catalog-my&quot;.&quot;catalog_my_20210425&quot; 
   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
  </code></pre>
  <p>and the second query</p>
  <pre><code>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 &quot;dasync&quot;.&quot;outputs_lazada_my&quot;a
    INNER JOIN &quot;catalog-my&quot;.&quot;catalog_my_20210425&quot;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;
  </code></pre>
  <p>please help me to combine these 2</p>