"Write an SQL query that displays the Ssn and Last name of all employees who is a supervisor of a Department Manager"

Answers

Answer 1
Answer:

Answer:

SELECT Ssn,

             Last_name

 FROM employees

WHERE position = supervisor;

Explanation:

SELECT is an SQL query statement that is used to initiate the display of wanted variables.

The names of the variables often succeed the SELECT statement and they are separated by commas.

FROM is an SQL query statement that indicates the table fro which the selected variables be displayed.

WHERE is used to filter your search and return only rows that meet the criteria.

; signifies the end of a query and calls for an execution.


Related Questions

Change the screen resolution so you can view more information on your screen. Use the resolution that enables you to fit the most information on the screen while still being able to read the display.Use the space below to indicate your screen resolution and to describe the steps you used to do this.
A constructor (check all that apply): Group of answer choices will always result in a run time error and program crash if it fails to test a parameter's value for validity before assigning the parameter's value to member. This will happen the first time we run a program, and alert us to the fact that there is a problem. must use mutators to initialize class data. must use assignment statements to initialize class data. may use assignment statements to initialize class data. may use mutators to initialize class data. will receive a compiler error if it fails to test a parameter's value for validity before assigning the parameter's value to member.
Assume that two computers are directly connected by a very short link with a bandwidth of 125 Mbps. One computer sends a packet of 1000 Bytes to the other computer. What’s the end-to-end delay (ignoring the propagation delay)?
Failing to include a complete ____ on each side of an && operator in an if statement is a common error in Java programming.a. operatorb. mathematical expressionc. variabled. Boolean expression
Assign True to the variable has_dups if the string s1 has any duplicate character (that is if any character appears more than once) and False otherwise.Here is the answer I wrote:i = []for i in range(len([s1])):if s1.count(s1[i]) > 1:has_dups = Trueelif s1.count(s1[i]) = 1:has_dups = FalseHere is the message I got from the system:Solutions with your approach don't usually use: elifPlease Help me to correct it.

Write a function in Matlab which takes as input an integer x and as output returns the biggest prime number that is less than or equal to x. For example, if the input is 7, the output would be 7. If the input is 40, the output would be 37. (Reminder: isprime.)

Answers

Answer:

Explanation:

The objective is to write a Matlab function getPrime()

CODE:

function prime = getPrime(x) %function definition for getPrime which receives x as input and returns prime.

   while (x >= 1) % loop until x is zero.

       if isprime(x) % matlab built-in function to check if x is a prime number.

           prime = x; % assign x to prime.

           break % break out of loop. we got the prime number value in variable prime.

       end

       x = x - 1; % when x is not prime, x is decremented by 1 and loop continues.

   end

end

prime = getPrime(12); % passes 12 to function.

disp(prime) % display value in prime. 11 is the output since it is the biggest prime number below 12.

Write a C++ program which accepts the quantity of a product purchased and prints the amount to be paid by the customer.​

Answers

Answer:

firstly the exel program is very useful to costumer or to calculate by Microsoft. People use it to company or office. It works for make good commination

You use utility software to_____. Select all that apply.A play video games
B reformat a hard disk drive
C manage fonts on a computer
D write and edit documents

Answers

You use utility software to:

  • Reformat a hard disk drive.
  • Manage fonts on a computer.

What are utility software used for?

Utility software are known to be a kind of software that is often used to  configure and maintain any system.

Conclusively, Note that this software is made up of  small programs which can be used to  Reformat a hard disk drive and also to Manage fonts on a computer.

Learn more about  utility software from

brainly.com/question/20659068

Utility software is system software designed to help analyze, configure, optimize or maintain a computer. Utility software usually focuses on how the computer infrastructure (including the computer hardware, operating system, software and data storage) operates.

Communicators do not have an ethical responsibility to share information that other people require to make informed decisions.True/False

Answers

Answer:

False.

Explanation:

A communicator is an individual who is obligated to clearly present information to an audience. There are two set of quality a communicator must have to win the trust of the audience, they are, the communicator must be prepared and ethical.

A prepared communicator must learn to organise his oral or written skills, must articulate very word and meaning of expression (clear) and a information must be brief and meaningful.

An ethical communicator must be impartial, trustworthy, respectful and must practice the golden rule. The information they give should help in making proper decisions to situations.

Make a program that asks for input from the user, apply eval to this input, and print out the type of the resulting object and its value. Test the program by providing five types of input: an integer, a real number, a complex number, a list, and a tuple.

Answers

Answer:

x = input("Input a number ")

print(eval("x"))

print ("Type is:",type(x))

#Taking an float input

y = input("Input a number ")

print(eval("y"))

print ("Type is:",type(y))

#Taking an complex input

z = complex(input("Input a number "))

print(eval("z"))

print ("Type is:",type(z))

#Taking an List input

L_num = raw_input().split(",")

print(eval("L_num"))

print ("Type is:",type(L_num))

#Taking an tuple input.

T_num = raw_input().split(",")

print(eval("T_num"))

print ("Type is:",type(T_num))

Explanation:

Hardware Name:Description:
Picture:
1. Motherboard





2. Power Supply



3. CPU (Central Processing Unit)



4. Random Access Memory (RAM)



5. Hard Disk Drive/Solid State Drive



6. Video Card



7. Optical Drives



8. Input and Output Devices

Answers

Answer:

I think 2.power supply yaar