CST221: Database Systems (II). Dr. Zhen Jiang Computer Science Department West Chester University West Chester, PA 19383. Querying. Creation (Query wizzard ) Save Use. Wildcard (*, ?), page AC87 Use criteria for a field not included in the result list, page AC88
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Dr. Zhen Jiang
Computer Science Department
West Chester University
West Chester, PA 19383
Show the name and age and salary of all employees who are younger than 25.
Show the Enum, name, salary of all employees whose names have 5 letters.
Show the name, Enum ,salary, and age of all employees with a salary > $40,000ANDyounger than 25
Show the Enumof all employees sorted by salary in the ascending order
List the LName of all employees in the department (Dnum) entered by the user.
List the LName of all employees with a new column labeled “hiring age”, which has a value by subtracting the years of working (wYears) from the current age (age).
Show the average age (label as “average age”) and average salary (label as “average salary”) for all employees
For all employees under 30, show a count of these employees and their average salary.
For all employees in department “D22” or “D28”, show a count of these employees, their average age, and maximum salary
For each department list avg, max and min age, along with a count of employees in each department.
For each department find a count and average salary for all employees younger than 40.
For each department with an average salary of >40000 list the dnums, employee count for these departments.
For each department with less than 4 employees, show the average age and number of employees.
For each department with more than 2 people over 40 list deptNum, and a count of these people.