Examine the following query:

SELECT

JOB, COUNT$(*)$ AS CONTRACTS

FROM

OUTSTANDING

GROUP BY

JOB

;

What will "COUNT$(*)"$ do$?$

Examine the following query:

SELECT

JOB, COUNT$(*)$ AS CONTRACTS

FROM

OUTSTANDING

GROUP BY

JOB

;

What will "COUNT$(*)"$ do$?$

It will rename the JOB attribute to CONTRACTS.

It will aggregate or sum all values of JOB.

It will aggregate or sum all values of CONTRACTS.

It will create a new attribute CONTRACTS.