SQL SERVER\

I am working on a project and need help with the following:

Write and execute the queries below in SQL Server. Take a screenshot of your query as well as the query results and paste it below each question.

1. Write and execute a query that will change the name of United Kingdom to Great Britain in the Countries table.
2. Write and execute a query that will increase every employees salary by 10%.
3. Write and execute a query that will change the contract type of every Time and Materials contract to Fixed Price.
4. Write and execute queries to delete the employee Paul Davis. [Note that before you remove him from the Employees table, you will need to remove his records from any other tables that refer to his ID.] You may use a separate query for each table that requires removal of Paul Daviss records, but only one query per table should be used. That is, if he has multiple records in the EmployeeProjectAssignments table, only one query should be used to remove all of his records in that table. You may also need to reassign any of the projects that he manages before you can delete him. That is, if Paul Davis manages any projects, reassign those projects to Matthew Smith. Do this in a single query as well. Write each query below that you used to remove Paul Davis from the database and then execute this Select statement:

Select * from employees where firstname = 'Paul' and lastname = 'Davis'

Take a screenshot of the results of this query and paste it below, as well.

5. Write and execute a query that will reassign all employees in the Cambridge office to the Denver office.
6. Write and execute a query that will end the employee project assignment for Mark Jones and the DT Work Order Customization project. Give the row an end date of August 1, 2017.
7. Write and execute a query that will remove the contract type Time and Materials from the ContractTypes table.
8. Write and execute a query that will delete all countries that are not assigned to an office or a client.

You must do this in a single query to receive credit for this question.

Write the delete query below and then execute the following statement in SQL Server: SELECT * from Countries

Tables Created: Regions, Countries, Offices, Employees, ContractTypes, Clients, Contracts, Projects, EmployeeProjectAssignments, and WorkHours.