Code in MySQL

5. Write an SQL SELECT statement that will return the following from the country table: Name, Region, Population, LifeExpectancy. Include only those countries where English is the official language and the population is greater than1 million Hint: You are displaying the results for the'country' table, based on a condition from the 'countryLanguage' table. You will need to use an embedded SELECT (see video Session 6 Part 3) The result set should look like the below figure Region Australia and New Zealand 18886000 North America Eastern Asia British Islands Southern Africa Australia and New Zealand 3862000 Southern Africa British Islands North America Eastern Africa Population LifeExpectancy Name Australia Canada Hong Kong Ireland Lesotho New Zealand South Africa United Kingdom United States Zimbabwe 79.8 79.4 79.5 76.8 50.8 77.8 40377000 51.1 777 278357000 77.1 37.8 311470ee 6782000 3775100 2153000 59623400 11669000