Please solve the question given below?????

Question

staff is being paid by hourly basis

staff.dbf
field name type width
staff_Id char. 4
name char 20
address char 20
rate numeric 6
working.dbf
field name type. width
staff_id. char 4
date date 8
hours numeric 2
1) list the staff with highest salary
2) find the no of days worked by all staff. in your display, list the name of the stass as well
.fill the according to you in table and do the questions.

Answer 1

You have completed the sql course and still can't solve this? I can solve this while flying blind and roasting sheep.

No one will do your homework for you Govind Pal, but we will help if we see an effort.

Answer 2

For 1), think of a query that gets the maximum salary, and use it as a subquery: list all the staff whose salary equals that maximum.
For 2) you have the hours and the staff_id in table working.dbf, and the relationship between staff_id and name into table staff.dbf. Try joining them together.

Answer 3

thank you Alvaro I will try

Answer 4

thank you Gavin for sugession...

Answer 5

thanks Alvaro I have solved the question....

Answer 6

mean but honest responses