1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
siniylev [52]
3 years ago
9

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.
Computers and Technology
2 answers:
Ghella [55]3 years ago
8 0

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

goldenfox [79]3 years ago
4 0

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)<u>,</u> and select it from <em>Employee</em> table.

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

<u />

You might be interested in
How do you hack a iPhone, Like If you forgot your password and want to get back in your phone. What do you do?
s344n2d4d5 [400]

Answer:

fix it on itunes

Explanation:

or get a new one

6 0
3 years ago
Read 2 more answers
1.6<br> What do you call the two parts of the lift that goes down a mine?
Likurg_2 [28]

Answer:

Sheave wheel and hoist cable

Explanation:

The sheave wheel is a pulley wheel that sits above the mine shaft. The hoist cable passes over the sheave wheel and then down the shaft of the mine. The sheave wheel reduces the sliding friction of the mine cable. The head frame is the structure that supports the sheave wheel.

7 0
3 years ago
Identity theft, where people steal personal information, continues to be a problem for consumers and businesses. Assume that you
svetlana [45]

Answer:

Secure the personal information with complex multi-factor authentication and configure intrusion detection and prevention and a firewall.

Explanation:

Multi-factor authentication is a method of securing a client's personal information from the client's side to the data centre. It uses more than one security processes not policies. There key be three authentications process like a password, security token and biometrics or two authentications like password and biometrics or token.

The firewall and intrusion detection and prevention are vulnerability preventive method to detect and stop cyber attacks.

5 0
3 years ago
The size of the board is one of the differences between Elevens and Thirteens. Why is size not an abstract method?
Levart [38]

Answer:

The program keeps track of the size of the board in cards.size(). The sub class sets this by passing it into the constructor. After that, the subclass never cares about the size of the board, so it's not necessary to make it accessible with an abstract method. Any need for it is covered by cardIndexes method.

Explanation:

The differences between Elevens and Thirteens

The program keeps track of the size of the board in cards.size(). The sub class sets this by passing it into the constructor. After that, the subclass never cares about the size of the board, so it's not necessary to make it accessible with an abstract method. Any need for it is covered by cardIndexes method.

5 0
3 years ago
What does an industry expect of you as an employee?<br><br> At least 3 please!
Hatshy [7]
Trusting, loyal, and a hard worker. All indristies want employees who won't backstab, works hard, and is loyal to the company
7 0
3 years ago
Read 2 more answers
Other questions:
  • What is client server relationship is the basic form of what
    6·1 answer
  • Here are the codes for producer and consumer problems.
    10·1 answer
  • Using an array, double each of the following values and print each result: values = [1.1, 10, 4.55, 30004, 0.2]
    7·1 answer
  • The first widely adopted windows product, ____, featured a standardized look and feel, similar to the one made popular by apple'
    11·1 answer
  • A haiku is a three-line poem in which the first line contains five syllables, the second line contains seven syllables, and the
    12·1 answer
  • How are computers used in producing weather forecasts?
    8·1 answer
  • 7.
    15·1 answer
  • Advantages and disadvantages of java
    10·1 answer
  • PLEASE HELP. Nobody has been helping me, i need to resolve this code issue for game design
    8·1 answer
  • If you want to stop a loop before it goes through all of its iterations, the break statement may be used. Group of answer choice
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!