1) UPDATE school SET country = 'Sweden' WHERE name='Durmstrang Institute';

2) UPDATE school SET capacity = 700 WHERE name='Mahoutokoro School of Magic';

3) DELETE FROM school WHERE name LIKE '%Magic%';

4) SELECT name, country, capacity FROM school;

+----------------------------------------------+----------------+----------+
| name                                         | country        | capacity |
+----------------------------------------------+----------------+----------+
| Castelobruxo                                 | Brasil         |      380 |
| Durmstrang Institute                         | Sweden         |      570 |
| Hogwarts School of Witchcraft and Wizardry   | United Kingdom |      450 |
| Ilvermorny School of Witchcraft and Wizardry | USA            |      300 |
| Koldovstoretz                                | Russia         |      125 |
+----------------------------------------------+----------------+----------+