Which of the following is a proper use of an aggregate function?
a. COUNT(DISTINCT Product ID)
b. SUM(AVG(Line Item Total))
c. AVG((SELECT Price FROM Products WHERE Category = 'Bikes'))
Correct Answer(s): A
a. COUNT(DISTINCT Product ID)
Computer Science & Information Technology
You might also like to view...
In Access, tables, queries, forms, and reports are all known generally as ________
Fill in the blank(s) with correct word
Computer Science & Information Technology
A server technician needs to access a remote Unix server for administration. The technician has requested that ports 23, 25, and 161 be opened on the router. After the ports are opened, the technician is still unable to connect to the Unix server. Which of the following ports should be opened on the server to allow for remote administration?
A. TCP 21 B. TCP 22 C. UDP 69 D. TCP 3389
Computer Science & Information Technology