Question: * Oracle Database * Question 3: Write a SQL query that display first name, last name and the job title of employees that their job

Question 3: Write a SQL query that display first name, last name and the job title of employees that their job ids are SA_MAN. (15 point) Answer 3: Question 4: Write a SQL query that display the first name, last name, department name and job title for the employees that works as a manager. (15 point) Answer 4: Question 5: Write a SQL query that display the first name, last name, department name and state province for emoloyees not works on Washington. (15 point) Answer 5: Question 6: Write a SQL query that display maximum salary for employees that works on Sales department. (15 point) Answer 6: Question 7: Write a SQL query that display department name and city for departments that their country id is UK. (15 point) Answer 7
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
