Question

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'.

Answer 1

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