Employees Employeeld - LastName • FirstName - Title TitleOfCourtesy 1 Davolio Nancy Sales Representative M. 2. Fuller An

[answerhappygod]

Employees Employeeld Lastname Firstname Title Titleofcourtesy 1 Davolio Nancy Sales Representative M 2 Fuller An 1 (75 KiB) Viewed 26 times

Employees Employeeld - LastName • FirstName - Title TitleOfCourtesy 1 Davolio Nancy Sales Representative M. 2. Fuller Andrew Vice President, Sales Dr. + 3 Levering Janet Sales Representative Ms. 4 Peacock Margaret Sales Representative Mrs. 5 Buchanan Steven Sales Manager Mr. 6 Suyama Michael Sales Representative Mr. 7 King Robert Sales Representative Mr. + 8 Callahan Laura Inside Sales Coordinato Ms. 9 Dodsworth Sales Representative Ms. Records of Norite Search Anne FullName Given the (Employees) table as shown, which SQL statement will generate result as below? As shown in the result, each employee has a full name and an employee ID. Employees in the result are sorted by their last names. Employeeld Buchanan, Steven Callahan, Laura Davolio, Nancy 1 Dodsworth, Anne Fuller, Andrew King, Robert Leverling, Janet Peacock, Margaret Suyama, Michael NOM DOO 6 SELECT PullName, EmployeeID FROM Employees ORDER BY Full Name O SELECT LastName + .' + FirstName AS FullName, EmployeeID FROM Employees SORT BY Last Name O SELECT FullName, EmployeeID FROM Employees SORT BY FullName O SELECT Last Name + ", • + FirstName As FullName, Employee ID FROM Employees ORDER BY Last Name O SELECT Last Name + FirstName AS FullName, Employee FROM Employees SORT BY Last Name