Question

please write a list of sql queries for these exercises

5. Display a list of countries whose official language is English. Show the names of the countries in alphabetical order.

Answer 1

sql query to display country names, whose official language is English, in sorted order.

To print Countries in sorted order use clause "ORDER BY "

-----------------------------------------------------

sql query:

________________________

SELECT country  

FROM COUNTRIES

WHERE language='English'

ORDER BY country