Web Development·11,944 discussions

SQL

Locked

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

Topic

Reply To: SQL

In reply to SQL

I e-mailed you with the answer, so you better give me the points here…. he he

Good Luck!

Reply To: SQL

In reply to Reply To: SQL

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.

Reply To: SQL

In reply to SQL

Hi, you
You should go to school better than ask us here.
Good Luck

Reply To: SQL

In reply to Reply To: SQL

any problem?
i already knew the answers by the way.

Reply To: SQL

In reply to SQL

This question was closed by the author

[Author]

Replies