Need help with the question below. Need help forming the query. Aggregating MySQ

Question

Need help with the question below. Need help forming the query.

Aggregating MySQL Table Data:

Using the world_x database you installed in Module 1, list the languages spoken in each country. Order your results by the most popular language. Submit your query and query results in a Word file. Cite any sources you used to research the syntax your needed to formulate your query. This is the link to the world_x sample database used for the problem above:

https://dev.mysql.com/doc/index-other.html Thanks

Explanation / Answer

If you have any doubts, please give me comment...

SELECT C.Name, C.Language

FROM Country C, CountryLanguage CL

WHERE C.Code = CL.CountryCode

GROUP BY C.Code

ORDER BY COUNT(*);

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

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