Question

Consider the above tables and execute the following queries
1. Find the names and rate of pay of all employees who has allocated a duty.
2. Give employee number who is working at posting_no. 201, but don’t have the
skill of waiter.
3. Display a list of names of employees who have skill of chef and who has assigned
a duty.
4. Display shift wise employee details.
5. Update payrate of employees to 20000 whose skill is waiter.

Answer 1

ikeiw iniinebij$kdkdmdjo(jjsjsjjs)jsnj(n