Web Development

General discussion

Gravatar
0 Votes
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

gravatar
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!

gravatar
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.

gravatar
Collapse -

by pnakiet In reply to SQL

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

gravatar
Collapse -

by Umer In reply to

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

gravatar
Collapse -

by Umer In reply to SQL

This question was closed by the author

Back to Web Development Forum

Start or search

Related Discussions

Related Forums