Write MySQL statements for each of the following queries: a. Get the part numbers and names of all the parts made in London. b. Get the part numbers and names shipped by supplier 2 . c. Get the supplier numbers and names of suppliers who have shipped a part made in the city they live. a. For each supplier, show the supplier's number, name, number of shipments, and the total quantity of parts the supplier has shipped. e. Get numbers and names of those red parts for which a total of at least 500 have been shipped. Your MySQL statements should be written in a text file queries.sql in your Linux account and will be tested on the Linux server using the following command: $ cat queries.sq1 mysql guest - q guest1 --password="guest1" The above command passes the queries to the mysql server which uses the database guest to obtain the output of each query. Here on Brightspace you are required to submit in the text area the full path name of your file queries.sql For example, write below something like this: /home/course/u00/as2/queries.sql