Programming Homework Help. ITS 410 CSUGC Database Management Performing an Advanced MySQL Query Worksheet
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.