$1.$ Create an update that changes the job code for employees with job code $777$ to $705.$

Paste a copy of the SQL code used and screenshots here:

$2.$ Which employee with job code $701$ has been at GatorWare Software the longest? Create a SQL statement that selects and displays empID, first, last, and hiredate for this employee only.

Paste a copy of the SQL code used and screenshots here:

$3.$ List all employees whose last name starts with the letter $$C$$ and sort by hiredate. Display empID, first, last, and hiredate.

Paste a copy of the SQL code used and screenshots here:

$4.$ Which SQL command would you use to delete all the records in the table GatorWareEmployee but not the table itself?

Paste a copy of the SQL code that would be used $($you do not have to run the code $-$but you can if you want to$!)$:

$5.$ Which SQL command would you use to remove the table GatorWareEmployee?

Paste a copy of the SQL code that would be used $($you do not have to run the code $-$but you can if you want to$!)$: