Write SQL queries to find the population of Cameroon, the population of Cameroon, Mauritius and Nigeria, and countries with an area between 250,000 and 300,000 sq. km.

Here are the solutions for the SQL queries based on the provided "Africa" database table:

1. Show the population of Cameroon.

• Query:

  SELECT population FROM Africa WHERE name = 'Cameroon';
  

  Copy
• Result: The country 'Cameroon' is not visible in the provided table data. Therefore, the query would return no rows or an empty result set based on the visible data.

2. Show the name and the population for 'Cameroon', 'Mauritius' and 'Nigeria'.

• Query:

  SELECT name, population FROM Africa WHERE name IN ('Cameroon', 'Mauritius', 'Nigeria');
  

  Copy
• Result: The countries 'Cameroon', 'Mauritius', and 'Nigeria' are not visible in the provided table data. Therefore, the query would return no rows or an empty result set based on the visible data.

3. Shows countries with an area of 250,000-300,000 sq. km.

• Query:

  SELECT name, area FROM Africa WHERE area BETWEEN 250000 AND 300000;
  

  Copy
• Result: Based on the visible table data, the country that fits this criterion is:
  • Burkina Faso, with an area of 272967 sq. km.