QUESTION

Employees on development projects

$\frac{0}{80}$

Ueing the tabletrol conetruct an $502$ query to retrime o list of all employees. For eoch employee, the query shoule disptay ther fulf narme the name of their deportment. the city where their department is bocated ond the name of any projects thent nontene the word 'Development' in the propect name. If an employee is not associated with amy project or if their project doesthot inctucte "Development" in its narre, the project name should be displayed os wiLi

Provide the SQL statement to achieve this outcome. The output should be ordered in the alphobetical order of LastName and incase of collision of ary same Last Name, sort the output on the basis of First Name.

Tables Schema as Below.

$\backslash$table$[[$Employees$],[$columnName$,$dataType$],[$EmployeelD$,$int$],[$FirstName$,$varchar$(100)],[$LostName$,$varchar$(100)],[$DepartmentiD$,$int$]]$

$\backslash$table$[[$Departments$],[$columnName$,$dataType$],[$DepartmentID$,$int$],[$DepartmentName$,$varchar$(100)],[$LocationID$,$int$],[$City$,$varchar$(100)],[$ProjectAssignments$,],[$columnName$,$dataType$],[$AssignmentiD$,$int$],[$EmployeelD$,$int$],[$ProjectName$,$varchar$(255)]]$