IT$201$ Gatorware Software SQL Practice Exercise I$*$IMPORTANT NOTES:$1.$ This lab is due this week. It is highly recommended that you DO NOT start this lab right before the due date. Start early, ask questions if you need clarification, and come in during office hours if necessary if you need help. $2.$ It is recommended to hand this lab in as a team project. All team members should submit the project in Canvas AND all team members MUST be listed on all copies of the assignment. I will provide all group comments and grades to each team member. Teams should consist of at most $5$ members. Just list all names at the top of this assignment worksheet$\mathrm{.}3.$ Download this worksheet and enter all of your responses on this worksheet in red font in the spaces provided. Upload the completed worksheet to Canvas when done.NOTE: Type out all your SQL code for each question so it is clearly legible. Often in screen shots the code editor is too small to accurately decipher an entire SQL script.Complete the following activities using the GatorwareEmployee table in the testbed database, show the SQL statement you used and the results of running the statement:$1.$ Create updates that set the hiredate to $2017-01-18$ for any employees that do not have a hiredate and the job code to $777$ for any employees that do not have a job code $($NOTE: You will need two update statements$).$Paste a copy of the SQL code used and screenshots here: $2.$ Display all employee records sorted by job code and then hire date using a single SQL statement.Paste a copy of the SQL code used and screenshots here: $3.$ List all job codes used by employees $-$no duplicates.Paste a copy of the SQL code used and screenshots here: $4.$ List only the four employees that have been working at Gatorware Software the longest. Display their empID, first name, last name, and hire date.Paste a copy of the SQL code used and screenshots here: $5.$ List only the four most recently hired employees at Gatorware Software. Display their empID, first name, last name, and hire date.Paste a copy of the SQL code used and screenshots here: