This exercise is based on the tables shown in the figure from the Adventure Works2008 database. These tables can be found on the SQL server via remote desktop. Department (Huma 9 DepartmentID Name GroupName ModifiedDate EmployeeDepartment History (Hu 9 BusinessEnttyID DepartmentID ShiftID StartDate EndDate ModifiedDate 8 EmployeePay History o Employee (HumanResources) BusinessEntityID Business EntityID RateChangeDate NationalIDNumber Rate LoginID PayFrequency OrganizationNode ModifiedDate OrganizationLevel Job Title BirthDate Marital Status Gender HireDate Please write the SQL statements to answer the following questions. 7. Create a new username (ken 7284) with the old username (ken) followed by last four digits of NationalIDNumber (7284) businessentityid 1 2 1 2 3 4 5 3 3 4 4 5 username ken7284 terri7967 roberto7174 rob7891 gail6908 jossef0692 dylan9118 diane 4146 gigi7903 michael2154 6 6 7 8 7 8 9 9 10 10