Slip 10 - D) 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.

Solution:

Post a Comment

0 Comments