Web Development

Ask something
Discussion Locked

SQL

0 helpful
5 replies

by umer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi
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

5 replies

by umer

Thanks.
I already knew the asnwers,
but for any reason, these were still giving problem, so i asked you. Few of your pseudo-codes still have problem, i dont know why.

This discussion is closed to new replies.