Display average employee salary by department, but do no include departments with average salary less than $75,000.

Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)


```
SQL> SELECT DeptId, AVG(Salary)
2 FROM employee
3 GROUP BY DeptId
4 HAVING AVG(Salary) >= 75000;

DEPTID AVG(SALARY)
---------- -----------
10 125000
40 150000
```

Computer Science & Information Technology

You might also like to view...

The Tab button which opens the Tabs dialog box is accessed in the ________ dialog box

Fill in the blank(s) with correct word

Computer Science & Information Technology

The four tunneling protocols used to establish VPN connections are PPTP, SSTP, IKEv2, and _______________________

a. L2TP b. PTP c. SSL d. None of the above.

Computer Science & Information Technology

Which of the following are true of the echo command?

A. When used to display text, quotation marks are optional. B. It can be used to display shell variables by including a $ sign in front of the variable name. C. Including a semicolon at the end of the line will not affect the text being displayed. D. All of the other options are true.

Computer Science & Information Technology

A server technician has been tasked with purchasing cables and connectors for a new server room. The server room consists of one switch, two servers, and one IP telephone. Which of the following types of cables and connectors should the technician purchase?

A. Coaxial cable and BNC connectors B. Straight through Ethernet cable and RJ-45 connectors C. Silver satin and RJ-11 connectors D. Crossover Ethernet cable and RJ-11 connectors

Computer Science & Information Technology