query example

SELECT *  FROM portfolio_top5
        WHERE
        (region="China") AND
        (stargate_market="Beijing" OR stargate_market="Changsha" OR stargate_market="Chengdu" OR stargate_market="Chongqing" OR stargate_market="Dongguan" OR stargate_market="Guangzhou" OR stargate_market="Hangzhou" OR stargate_market="Hong Kong" OR stargate_market="N/A" OR stargate_market="Nanjing" OR stargate_market="Qingdao" OR stargate_market="Shanghai" OR stargate_market="Shenyang" OR stargate_market="Shenzhen" OR stargate_market="Suzhou" OR stargate_market="Taipei" OR stargate_market="Tianjin" OR stargate_market="Wuhan" OR stargate_market="Wuxi" OR stargate_market="Xi'an" OR stargate_market="Xiamen") AND
        (gate="A" OR gate="B" OR gate="C" OR gate="D")