Instruction: Edit Astrazeneca PLC to Astrazeneca and delete Sinovac.
UPDATE company SET name="Astrazeneca" WHERE name="Astrazeneca PLC";
DELETE FROM company WHERE name="Sinovac"
| name | symbol | country |
|---|---|---|
| Johnson & Johnson | JNJ | US |
| Pfizer | PFE | US/Germany |
| Moderna | MRNA | US |
| Astrazeneca | AZN | UK |
| GlaxoSmithkilne | GSK | UK/France |
| Novavax | NVAX | US |
| Casino Biologics | 6185[Hong Kong] | China |
No comments:
Post a Comment