IE 4425 Chapter : Assignment02 Lab3
Document Summary
Sql problems: for problems 1-21, develop & turn in the sql queries to: list employee id, lastname, and firstname for all employees. Select employeeid, lastname, firstname from employees: repeat #1, using field aliases to rename lastname to [last name] and firstname to [first name]. Select employeeid, lastname as [last name], firstname as [first name] From employees: list only distinct lastname, firstname combinations (i. e. , no duplicates). Select distinct lastname, firstname from employees: return the names and annual salary of the top 10 percent highest paid employees. Order by annualsalary desc: return the names and annual salary of the 15 lowest performing employees. Select top 15 lastname, firstname, annualsalary from employees order. By lastperformancerating: for each employee, list their name and "daily salary" assuming 250 working days per year. Salary] from employees: list the max, min, avg, and sum of annual salary for employees of the accounting department.