General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
SQL
Can anyone help in giving query code for these problems:
1- List the surname of any employee who does not have an e in their surname.
2- Find the number of jobs employee 22 has had or has currently.
3- List all of the empnos of employees and their position in 1984.
4- What was the average salary in 1988? Look at employees who where employed on the last day of 1988.
5- Count the number of employee who has a forename starting with M or A.
6-List the employee numbers and telephone numbers ordered by descenending