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
```
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
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.
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.
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