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'))


a. COUNT(DISTINCT Product ID)

Computer Science & Information Technology

You might also like to view...

Which of the following is a variable declaration statement?

a. int total; b. import java.util.Scanner; c. public static void main(String args[]) d. // first string entered by user

Computer Science & Information Technology

To record the starting address of each of its files, a portion of the disk’s first track is set aside to hold a(n) __________.

a. directory b. index c. boot record d. table

Computer Science & Information Technology

A String constructor cannot be passed ________.

a. char arrays. b. int arrays. c. byte arrays. d. Strings.

Computer Science & Information Technology

____ are continuous waveforms.

A. Analog signals B. Application programs C. Digital signals D. System programs

Computer Science & Information Technology