Write the SQL code that will select the MOD$\_$CODE and MOD$\_$MANUFACTURER from the

MODEL table where the MOD$\_$CODE starts with $$C$.$

$2.$ Write the SQL code that will select the EMP$\_$NUM, EMP$\_$LNAME and EMP$\_$FNAME from the

EMPLOYEE table where the EMP$\_$FNAME is only five characters in length.

$3.$ Using the data in the CHARTER table, write the SQL code that will yield the sum CHAR$\_$DISTANCE

grouped by CHAR$\_$DESTINATION. The results of running this query are shown below.