Instruction: Give me all the Covid-19 Vaccine Candidates in the US and exclude companies in China.
ALTER TABLE company ADD FULLTEXT (country)
SELECT name, symbol, country FROM company
WHERE Match(country) Against("+US - CHINA" IN BOOLEAN MODE)
| name | symbol | country |
|---|---|---|
| Johnson & Johnson | JNJ | US |
| Pfizer | PFE | US/Germany |
| Moderna | MRNA | US |
| Astrazeneca PLC | AZN | UK |
| GlaxoSmithkilne | GSK | UK/France |
| Novavax | NVAX | US |
No comments:
Post a Comment