Database management system
Posts  1 - 1  of  1
Help999
I need to Create and save the following queries in SQL
Can any one help
1. List matriculation number, last name, and sex of all students who are studying the 'Database Systems' module. Order result alphabetically by last name.

2. List staff number, last name, sex, and post of all academic staff who have the highest salary.


3. List staff number, last name, sex, and post of all academic staff who have the second highest salary.

4. List staff number, last name, sex, and post of all academic staff whose salary is greater than the average salary of all academic staff.



Can any one help
Save
Cancel
Reply
 
x
OK