you will use the my_guitar_shop databaseto answer the questions in this assignment. Please download the script file https://www.dropbox.com/s/o966abkh72nc3sn/create_my_guitar_shop.sql?dl=0 and build the database on your server before starting your work on the questions if you have not already done so. Please contact the instructors if you encounter problems downloading or running the database script.

You may lose points if you use more than one query for each of questions 1, 2, 3, 5, and 6, and more than two queries for question 4.

For this assignment, you are not allowed to use the LIMIT keyword to filter result rows in any of your SELECT queries. You may lose points if you do so.

For this assignment, you are not allowed to use exact match conditions to filter result rows in any of your SELECT queries. For example, you cannot use ... WHERE last_name=Smith... in a SELECT query. You may lose points if you do so.

Q.1) (15 points) Write an INSERT statement that adds this row to the Addresses table customer_id: 6 Linel: 12765 Lark Str. Line2 : Apt 2e1 city: College Park state: MD zip_code: 20742 phonc: 301-999-8888 disabled: Code the INSERT statement so MySQL automatically generates the address_id column Q.2) (15 points) Write an INSERT statement that adds this row to the Orders table /*The next automatically generated ID order id : customer_id: 6 order_date: /*Assume the order is taken on September 25, 2017, at 11:35:18 AM* ship_amount: 5 tax _amount: e ship_date: *Do not hard code the date and time; use a function that wiLL insert the date and time at the moment when the record is added.* ship_address_id: *Use the address_id value of the record added in Q.1* card_type: Visa card_number: 123456789e123456 card_expires: e6/2019 billing_address id: 8 Use a column list for this statement Q.3) (15 points) Write an UPDATE statement that modifies the order you added in Question 2 above. This statement should change the tax amount column from 0 to 3.60