Question

Write an SQL statement to display full name of employees supervised by the manager whose ID is 105. Note that full name includes first name, a space, and last name. Also note the caption/heading of the query output. Sample query output is shown below for your guidance.

Answer 1

Answer:

SELECT CONCATENATE(FIRST_NAME, " ", LAST_NAME) as FULL_NAME FROM TABLE_NAME WHERE MANAGER_ID = 105;

Explanation:

SELECT IS THE KEYWORD TO FETCH DATA

CONCATENATE combines FIRST_NAME, " " AND LAST_NAME and displays as FULL_NAME

TABLE_NAME is the name of the table containing the data

MANAGER _ID is the name of the column containing the manager id data

Answer 2

Answer:

SQL

//////////////////////////////////////////////////////////////////////////////////

Select first_name + ' ' + last_name as [Full Name]

From Employee

Where manager_Id = 105

Explanation:

First thing is to combine the first and last name columns into one and label it as Full Name (you have to use square brackets or double quotations, if the alias or label contain spaces), and select it from Employee table.

And lastly, place the where condition for the supervisor/manager.