Slip 1 - D) Consider the above database and execute the following queries: 1. Display the count of employees department wise. 2. Display the name of employee who is ‘Manager’ of “Account Department”. 3. Display the name of department whose location is “Pune” and “Mr. Advait” is working in it. 4. Display the names of employees whose salary is greater than 50000 and department is “Quality”. 5. Update Dateofjoining of employee to ‘15/06/2019’ whose department is ‘computer science’ and name is “Mr. Roy’.

Solution:



Post a Comment

0 Comments