Question: Using SQL developer 1. Write a query to print department names and their full address of the location in column, if the department is located
1. Write a query to print department names and their full address of the location in column, if the department is located in UK. (5 points) Ex) Address 8204 Arthur St, London UK Human Resources 2. Print out the name of the managers and the employees who work under the managers. Even if there is no employee under manager, all manager should be shown in the result. (10 points) 3. Convert to the following query to ANSI format (Use JOINDN but USING). (10 points) SELECT FROM locations, departments WHERE locations.location id Ci 1. Write a query to print department names and their full address of the location in column, if the department is located in UK. (5 points) Ex) Address 8204 Arthur St, London UK Human Resources 2. Print out the name of the managers and the employees who work under the managers. Even if there is no employee under manager, all manager should be shown in the result. (10 points) 3. Convert to the following query to ANSI format (Use JOINDN but USING). (10 points) SELECT FROM locations, departments WHERE locations.location id Ci
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
