$2.$ Insert the following $2$ employee data into EMP$\_1$ table.

$3.$ Write the SQL code that will list all attributes for a job code of $502.$

$4.$ Write the SQL code to change the job code to $501$ for the person whose employee number $($EMP$\_$NUM$)$ is $107.$ After you have completed the task and examine the results by displaying that employee$$s data

$5.$ Write the SQL code to delete the row for the person named William Smithfield, who was hired on June $22,2004,$ and whose job code classification is $500.($Hint: Use logical operators to include all of the information given in this problem.$)$

$6.$ Write the SQL code required to list all employees whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in the listing. Assume case sensitivity$.$

$7.$ Write the SQL code to find the average Assign$\_$Charge from the Assignment table.

$8.$ Write the SQL code to find the minimum and maximum Charge$\_$Hours from the Assignment table.

$9.$ Write the SQL code to find how many employees are in job$\_$code $501.$

$10.$ Write the SQL code to find how many assignments are associated with each project.