Open the World database on MySQL and set the command to use it. Run the following SQL and observe the resulting error. What should you do to fix the error?

SELECT country.name AS 'Country Name', city.Name AS 'City Name', GNP,

SUM(city.Population) AS totalpopulation

FROM city, country

WHERE city.countrycode = country.code

GROUP By Name

HAVING totalpopulation > 5000000

ORDER BY country.name, city.name;

Select one:

a. Fix the syntax in the SELECT statement

b. Change the query to use an Inner Join.

c. Change the WHERE clause by adding conditional logic.

d. Preface a specific field name with the correct the table name and a period.

e. None of the above.