Web Development

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion

Locked

SQL

By Umer ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by MadestroITSolutions In reply to SQL

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

Good Luck!

Collapse -

by Umer In reply to

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.

Collapse -

by pnakiet In reply to SQL

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

Collapse -

by Umer In reply to

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

Collapse -

by Umer In reply to SQL

This question was closed by the author

Related Discussions

Related Forums