All categories

3 years ago

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

Computers and Technology

1 answer:

Karo-lina-s [1.5K]3 years ago

3 0

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.

You might be interested in

general electric always includes an owner registration form with its products. it asks customers for their names, addresses, pho

Marysya12 [62]

The registration, general electric can then sell the information and use it for its own buyer directory. Thus option (A) is correct.

<h3>What is information?</h3>

Information is a general term for everything with the capacity to inform. Information is most fundamentally concerned with the interpretation of what may be sensed. Any naturally occurring process that is not entirely random, as well as any discernible pattern in any medium, can be said to convey some level of information.

An international business based in America is called The General Electric Company (GE). GE has created the technology that will shape the industry for more than 125 years. For its work in the power, renewable energy, aviation, and healthcare sectors, GE is best known today.

Therefore, Thus option (A) is correct.

Learn more about the information here:

brainly.com/question/13629038

#SPJ1

8 0

1 year ago

The _____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the

slava [35]

Answer: the accounting number format

Explanation:

The standard accounting number format usually contains a dollar sign, a thousands separator and two decimal points, the dollar sign is locked to the far left side of the cell in an enclosure.

How to apply the accounting number format ;

I, select the range and right-click and choose Format Cells.

Ii. In the Format Cells Dialog box, with the Number Tab selected, choose Accounting

Iii. Accept the options shown below and click Ok.

The Accounting Format has been applied.

4 0

3 years ago

Is an example of a relational database management system? (ORACLE ,SQL,JAVA,Python)

olganol [36]

Answer:

The correct answer for the given question is "ORACLE ".

Explanation:

ORACLE is an relational database management system oracle can store the interrelated data .Oracle database management system is used for online transaction etc .It is first company in Relational database management System.

SQL is an structural query language it is used to communicate with a database it is not relational database management system so this option is wrong.

Java and python are the programming language they are not relational database management system so this option is wrong.

So correct answer is "ORACLE "

6 0

3 years ago

In the late 1990s, Microsoft was sued for "tying" its Internet browser, Internet Explorer, to its operating system. A seller for

LekaFEV [45]

Answer:

Section 3 of the Clayton act.

Explanation:

Section 3 of the Clayton act 15 U.S.C.S § 14, makes illegal some kind of distribution practice that facilitates monopolistic arrangement that is section 3 of the Clayton act makes it illegal to enter into tying arrangement, exclusive dealing contracts or requirement contracts if such contracts tends to lessen competition. Where customer is required to pay for an undesired product in order to obtain a desired product.

3 0

3 years ago

Explain The main distinction between an ap course and a dual enrollment course.

V125BC [204]

Answer:

Overall, the main difference between the courses is the fact that AP classes require an AP exam, while Dual Enrollment classes just require a passing grade. This causes colleges to favor AP classes because they know exactly what you learned based on what you knew on the AP exam.

5 0

4 years ago