Question 1

(A) Write the corresponding SQL statement for the following query:

For each continent, show the number of countries that have Constitutional Monarchy as form of government.

(B) Write a trigger that will implement the following policy:

If the population of a particular city is decreased by any value larger than 10% from its current population size, then decrease the population of every country on the same continent as the country of the updated city by 5%.