critical thinking 3 its 410 1

Choose one of the following two assignments to complete this week. Do not do both assignments. Identify your assignment choice in the title of your submission.

Option #1: Performing an Advanced MySQL Query

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.

Option #2: Performing an Advanced MySQL Query

Using the classicmodels database you installed in Module 1, list the office codes, phone numbers, and addresses located in San Francisco, Paris, Sydney, and London. Sort your results by office code. Submit your query and query results in a text file.

In your document, suggest another query where you list the same information cities other than San Francisco, Paris, Sydney, and London. Be sure to identify the literary sources you used to look up any SQL syntax you used to formulate your query.