Need help writing the query situation below. And with the 2nd paragraph asking f

Question

Need help writing the query situation below. And with the 2nd paragraph asking for another query example that applies here. Thx

Using the world_x database you installed in Module1, list the codes for countries where English is spoken by more than 30% of the population. Submit your query and query results in a Word file.

In your document, suggest another query where you list the country codes for countries where English is spoken by less than 30% of the population. Be sure to identify the literary sources you used to look up any SQL syntax you used to formulate your query.

Explanation / Answer

Query: Codes for countries where English is spoken by more than 30% of the population

SELECT country_code

FROM world_x

WHERE language = 'English' AND population>30;

Query: country codes for countries where English is spoken by less than 30% of the population

SELECT country_code

FROM world_x

WHERE language = 'English' AND population<30;

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.