1.

Consider the above tables and execute the following queries1. 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 theskill of waiter.3. Display a list of names of employees who have skill of chef and who has assigneda duty.4. Display shift wise employee details.5. Update payrate of employees to 20000 whose skill is waiter.

Answer»

ikeiw iniinebij$kdkdmdjo(jjsjsjjs)jsnj(N



Discussion

No Comment Found

Related InterviewSolutions