Assume you have a table with the following information for all countries.
CCODE CNAME CONTINENT LANGUAGE POPULATION LAND WATER
1 Afghanistan AS fa 30419928.00 652230 NULL
2 Albania EU sq 3002859.00 27398 1350
3 Algeria AF ar 35406303.00 2381741 NULL
�� �� �� �� �� �� ��
Use this table to answer Q1-Q10 (1 Point Each).
Answer each question as best as possible.
Show your work if you need to take multiple steps to answer a problem.
Partial answers will count.
A. Write a SQL query to answer: What is the average population of countries who speak English ('en') and whose name start and end with 'a'.
A.answer)
SELECT AVG(POPULATION) FROM countries WHERE CNAME LIKE a%a AND
LANGUAGE="en";
here AVG is a aggrigate function used to find the average population
Like operation used to string comparision. a%a meas starts with a and end with a in between anything come.
counties is a table name
Assume you have a table with the following information for all countries. CCODE CNAME CONTINENT LANGUAGE POPULATION  
if you do not have the world schema you can obtain the scripts to create the database schema from https://dev.mysql.com/doc/index-other.html Queries Write a SQL query that shows all the columns in the country table for the North America region. The results need to be sorted in ascending order by population. Write a SQL query that shows the unique regions in the country table except for the regions from the continent of Oceania. The results need to be sorted in ascending...