EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7369 Smith Clerk 7902 17-DEC-90 800 200
7900 James Clerk 7698 03-DEC-91 950 300
7876 Adams Clerk 7788 23-SEP-91 1100 400
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
7782 Raimi Manager 7839 09-JUN-91 2450 100
7698 Blake Manager 7839 01-MAY-91 2850 300
7566 Jones Manager 7839 02-APR-91 2975 200
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7788 Scott Analyst 7566 09-NOV-91 3000 200
7902 Ford Analyst 7566 03-DEC-91 3000 200
7839 King President 17-NOV-91 5000 500
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7369 Smith Clerk 7902 17-DEC-90 800 200
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7566 Jones Manager 7839 02-APR-91 2975 200
7698 Blake Manager 7839 01-MAY-91 2850 300
7782 Raimi Manager 7839 09-JUN-91 2450 100
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7876 Adams Clerk 7788 23-SEP-91 1100 400
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
7788 Scott Analyst 7566 09-NOV-91 3000 200
7839 King President 17-NOV-91 5000 500
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7902 Ford Analyst 7566 03-DEC-91 3000 200
7900 James Clerk 7698 03-DEC-91 950 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7902 Ford Analyst 7566 03-DEC-91 3000 200
7788 Scott Analyst 7566 09-NOV-91 3000 200
7369 Smith Clerk 7902 17-DEC-90 800 200
7934 Miller Clerk 7782 23-JAN-92 1300 100
7876 Adams Clerk 7788 23-SEP-91 1100 400
7900 James Clerk 7698 03-DEC-91 950 300
7698 Blake Manager 7839 01-MAY-91 2850 300
7782 Raimi Manager 7839 09-JUN-91 2450 100
7566 Jones Manager 7839 02-APR-91 2975 200
7839 King President 17-NOV-91 5000 500
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
14 rows selected.
EMPL_LAST_NAME
---------------
Smith
James
Adams
Martin
Ward
Miller
Turner
Michaels
Raimi
Blake
Jones
EMPL_LAST_NAME
---------------
Scott
Ford
King
14 rows selected.
SALARY EMPL_LAST_NAME
---------- ---------------
2850 Blake
2975 Jones
2450 Raimi
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7788 Scott Analyst 7566 09-NOV-91 3000 200
7902 Ford Analyst 7566 03-DEC-91 3000 200
7900 James Clerk 7698 03-DEC-91 950 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
7876 Adams Clerk 7788 23-SEP-91 1100 400
7369 Smith Clerk 7902 17-DEC-90 800 200
7566 Jones Manager 7839 02-APR-91 2975 200
7698 Blake Manager 7839 01-MAY-91 2850 300
7782 Raimi Manager 7839 09-JUN-91 2450 100
7839 King President 17-NOV-91 5000 500
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
7902 Ford Analyst 7566 03-DEC-91 3000 200
7369 Smith Clerk 7902 17-DEC-90 800 200
7934 Miller Clerk 7782 23-JAN-92 1300 100
7566 Jones Manager 7839 02-APR-91 2975 200
7782 Raimi Manager 7839 09-JUN-91 2450 100
7788 Scott Analyst 7566 09-NOV-91 3000 200
7839 King President 17-NOV-91 5000 500
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7876 Adams Clerk 7788 23-SEP-91 1100 400
7900 James Clerk 7698 03-DEC-91 950 300
7698 Blake Manager 7839 01-MAY-91 2850 300
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7788 Scott Analyst 7566 09-NOV-91 3000 200
7902 Ford Analyst 7566 03-DEC-91 3000 200
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
7900 James Clerk 7698 03-DEC-91 950 300
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
7876 Adams Clerk 7788 23-SEP-91 1100 400
7566 Jones Manager 7839 02-APR-91 2975 200
7782 Raimi Manager 7839 09-JUN-91 2450 100
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7698 Blake Manager 7839 01-MAY-91 2850 300
7369 Smith Clerk 7902 17-DEC-90 800 200
7839 King President 17-NOV-91 5000 500
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7839 King President 17-NOV-91 5000 500
7902 Ford Analyst 7566 03-DEC-91 3000 200
7788 Scott Analyst 7566 09-NOV-91 3000 200
7566 Jones Manager 7839 02-APR-91 2975 200
7698 Blake Manager 7839 01-MAY-91 2850 300
7782 Raimi Manager 7839 09-JUN-91 2450 100
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7876 Adams Clerk 7788 23-SEP-91 1100 400
7900 James Clerk 7698 03-DEC-91 950 300
7369 Smith Clerk 7902 17-DEC-90 800 200
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
7839 King President 17-NOV-91 5000 500
7782 Raimi Manager 7839 09-JUN-91 2450 100
7698 Blake Manager 7839 01-MAY-91 2850 300
7566 Jones Manager 7839 02-APR-91 2975 200
7900 James Clerk 7698 03-DEC-91 950 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
7876 Adams Clerk 7788 23-SEP-91 1100 400
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7369 Smith Clerk 7902 17-DEC-90 800 200
7902 Ford Analyst 7566 03-DEC-91 3000 200
7788 Scott Analyst 7566 09-NOV-91 3000 200
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7369 Smith Clerk 7902 17-DEC-90 800 200
7900 James Clerk 7698 03-DEC-91 950 300
7876 Adams Clerk 7788 23-SEP-91 1100 400
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
7782 Raimi Manager 7839 09-JUN-91 2450 100
7698 Blake Manager 7839 01-MAY-91 2850 300
7566 Jones Manager 7839 02-APR-91 2975 200
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7902 Ford Analyst 7566 03-DEC-91 3000 200
7788 Scott Analyst 7566 09-NOV-91 3000 200
7839 King President 17-NOV-91 5000 500
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7839 King President 17-NOV-91 5000 500
7566 Jones Manager 7839 02-APR-91 2975 200
7698 Blake Manager 7839 01-MAY-91 2850 300
7782 Raimi Manager 7839 09-JUN-91 2450 100
7902 Ford Analyst 7566 03-DEC-91 3000 200
7876 Adams Clerk 7788 23-SEP-91 1100 400
7934 Miller Clerk 7782 23-JAN-92 1300 100
7369 Smith Clerk 7902 17-DEC-90 800 200
7900 James Clerk 7698 03-DEC-91 950 300
7788 Scott Analyst 7566 09-NOV-91 3000 200
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7698 Blake Manager 7839 01-MAY-91 2850 300
7566 Jones Manager 7839 02-APR-91 2975 200
7788 Scott Analyst 7566 09-NOV-91 3000 200
7902 Ford Analyst 7566 03-DEC-91 3000 200
7839 King President 17-NOV-91 5000 500
order by salary)
*
ERROR at line 7:
ORA-00907: missing right parenthesis
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7900 James Clerk 7698 03-DEC-91 950 300
7782 Raimi Manager 7839 09-JUN-91 2450 100
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
7788 Scott Analyst 7566 09-NOV-91 3000 200
7876 Adams Clerk 7788 23-SEP-91 1100 400
7934 Miller Clerk 7782 23-JAN-92 1300 100
7839 King President 17-NOV-91 5000 500
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
7698 Blake Manager 7839 01-MAY-91 2850 300
7369 Smith Clerk 7902 17-DEC-90 800 200
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7902 Ford Analyst 7566 03-DEC-91 3000 200
7566 Jones Manager 7839 02-APR-91 2975 200
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
14 rows selected.
AVG(SALARY)
-----------
2073.21429
AVG(SALARY)
-----------
2758.33333
3000
1037.5
5000
1400
JOB_TITLE AVG(SALARY)
---------- -----------
Manager 2758.33333
Analyst 3000
Clerk 1037.5
President 5000
Salesman 1400
DEPT_NAME AVG(SALARY)
--------------- -----------
Operations 1100
Sales 1566.66667
Accounting 1875
Research 2443.75
Management 5000
DEPT_NAME AVG(SALARY)
--------------- -----------
Operations 1100
Sales 1566.66667
Accounting 1875
Research 2443.75
Management 5000
COUNT(*) DEP MIN(SALARY) MAX(SALARY) MIN(HIRED MAX(HIRED SUM(SALARY)
---------- --- ----------- ----------- --------- --------- -----------
4 200 800 3000 17-DEC-90 03-DEC-91 9775
6 300 950 2850 20-FEB-91 03-DEC-91 9400
1 400 1100 1100 23-SEP-91 23-SEP-91 1100
2 100 1300 2450 09-JUN-91 23-JAN-92 3750
1 500 5000 5000 17-NOV-91 17-NOV-91 5000
select dept_num, empl_last_name, min(salary), max(salary),
*
ERROR at line 1:
ORA-00979: not a GROUP BY expression
select d.dept_num, dept_name, min(salary), max(salary),
*
ERROR at line 1:
ORA-00979: not a GROUP BY expression
select d.dept_num, dept_name, min(salary), max(salary),
*
ERROR at line 1:
ORA-00979: not a GROUP BY expression
DEP DEPT_NAME MIN(SALARY) MAX(SALARY) MIN(HIRED MAX(HIRED
--- --------------- ----------- ----------- --------- ---------
200 Research 800 3000 17-DEC-90 03-DEC-91
500 Management 5000 5000 17-NOV-91 17-NOV-91
100 Accounting 1300 2450 09-JUN-91 23-JAN-92
400 Operations 1100 1100 23-SEP-91 23-SEP-91
300 Sales 950 2850 20-FEB-91 03-DEC-91
DEP DEPT_NAME MIN(SALARY) MAX(SALARY) MIN(HIRED MAX(HIRED
--- --------------- ----------- ----------- --------- ---------
200 Research 800 3000 17-DEC-90 03-DEC-91
500 Management 5000 5000 17-NOV-91 17-NOV-91
100 Accounting 1300 2450 09-JUN-91 23-JAN-92
400 Operations 1100 1100 23-SEP-91 23-SEP-91
300 Sales 950 2850 20-FEB-91 03-DEC-91
JOB_TITLE MGR AVG(SALARY) COUNT(*)
---------- ---- ----------- ----------
Analyst 7566 3000 2
Clerk 7782 1300 1
Manager 7839 2758.33333 3
Salesman 7698 1400 4
President 5000 1
Clerk 7902 800 1
Clerk 7788 1100 1
Clerk 7698 950 1
8 rows selected.
DEP DEPT_NAME MIN(SALARY) MAX(SALARY) MIN(HIRED MAX(HIRED
--- --------------- ----------- ----------- --------- ---------
200 Research 800 3000 17-DEC-90 03-DEC-91
500 Management 5000 5000 17-NOV-91 17-NOV-91
100 Accounting 1300 2450 09-JUN-91 23-JAN-92
400 Operations 1100 1100 23-SEP-91 23-SEP-91
300 Sales 950 2850 20-FEB-91 03-DEC-91
DEP DEPT_NAME MIN(SALARY) MAX(SALARY) MIN(HIRED MAX(HIRED
--- --------------- ----------- ----------- --------- ---------
200 Research 800 3000 17-DEC-90 03-DEC-91
500 Management 5000 5000 17-NOV-91 17-NOV-91
100 Accounting 1300 2450 09-JUN-91 23-JAN-92
400 Operations 1100 1100 23-SEP-91 23-SEP-91
300 Sales 950 2850 20-FEB-91 03-DEC-91
DEP EMPL_LAST_NAME MIN(SALARY) MAX(SALARY) MIN(HIRED MAX(HIRED
--- --------------- ----------- ----------- --------- ---------
300 Michaels 1600 1600 20-FEB-91 20-FEB-91
300 Ward 1250 1250 22-FEB-91 22-FEB-91
300 Turner 1500 1500 08-SEP-91 08-SEP-91
400 Adams 1100 1100 23-SEP-91 23-SEP-91
200 Smith 800 800 17-DEC-90 17-DEC-90
300 James 950 950 03-DEC-91 03-DEC-91
100 Raimi 2450 2450 09-JUN-91 09-JUN-91
200 Scott 3000 3000 09-NOV-91 09-NOV-91
100 Miller 1300 1300 23-JAN-92 23-JAN-92
300 Blake 2850 2850 01-MAY-91 01-MAY-91
200 Ford 3000 3000 03-DEC-91 03-DEC-91
DEP EMPL_LAST_NAME MIN(SALARY) MAX(SALARY) MIN(HIRED MAX(HIRED
--- --------------- ----------- ----------- --------- ---------
500 King 5000 5000 17-NOV-91 17-NOV-91
300 Martin 1250 1250 28-SEP-91 28-SEP-91
200 Jones 2975 2975 02-APR-91 02-APR-91
14 rows selected.
DEPT_NAME JOB_TITLE
--------------- ----------
Accounting Clerk
Management President
Sales Manager
Accounting Manager
Research Clerk
Research Manager
Operations Clerk
Sales Clerk
Research Analyst
Sales Salesman
10 rows selected.
DEPT_NAME JOB_TITLE
--------------- ----------
Accounting Clerk
Management President
Sales Manager
Accounting Manager
Research Clerk
Research Manager
Operations Clerk
Sales Clerk
Research Analyst
Sales Salesman
10 rows selected.
DEPT_NAME JOB_TITLE
--------------- ----------
Accounting Clerk
Management President
Sales Manager
Accounting Manager
Research Clerk
Research Manager
Operations Clerk
Sales Clerk
Research Analyst
Sales Salesman
10 rows selected.
DEPT_NAME JOB_TITLE
--------------- ----------
Accounting Clerk
Management President
Sales Manager
Accounting Manager
Research Clerk
Research Manager
Operations Clerk
Sales Clerk
Research Analyst
Sales Salesman
10 rows selected.
DEPT_NAME JOB_TITLE COUNT(*) AVG(SALARY)
--------------- ---------- ---------- -----------
Accounting Clerk 1 1300
Management President 1 5000
Sales Manager 1 2850
Accounting Manager 1 2450
Research Clerk 1 800
Research Manager 1 2975
Operations Clerk 1 1100
Sales Clerk 1 950
Research Analyst 2 3000
Sales Salesman 4 1400
10 rows selected.
DEPT_NAME JOB_TITLE COUNT(*) AVG(SALARY)
--------------- ---------- ---------- -----------
Accounting Clerk 1 1300
Management President 1 5000
Sales Manager 1 2850
Accounting Manager 1 2450
Research Clerk 1 800
Research Manager 1 2975
Operations Clerk 1 1100
Sales Clerk 1 950
Research Analyst 2 3000
Sales Salesman 4 1400
10 rows selected.
MGR MIN(HIRED COUNT(*)
---- --------- ----------
17-NOV-91 1
7902 17-DEC-90 1
7839 02-APR-91 3
7566 09-NOV-91 2
7698 20-FEB-91 5
7782 23-JAN-92 1
7788 23-SEP-91 1
7 rows selected.
EMPL_LAST_NAME SALARY
--------------- ----------
King 5000
Jones 2975
Blake 2850
Raimi 2450
Ford 3000
Michaels 1600
Ward 1250
Martin 1250
Scott 3000
Turner 1500
Adams 1100
EMPL_LAST_NAME SALARY
--------------- ----------
Miller 1300
12 rows selected.
MIN(AVG(SALARY))
----------------
1100
DEPT_NAME
---------------
Operations
DEPT_NAME
---------------
Operations
DEPT_NAME
---------------
Operations
DEP MIN(SALARY) MAX(SALARY) MIN(HIRED MAX(HIRED SUM(SALARY)
--- ----------- ----------- --------- --------- -----------
200 800 3000 17-DEC-90 03-DEC-91 9775
300 950 2850 20-FEB-91 03-DEC-91 9400
400 1100 1100 23-SEP-91 23-SEP-91 1100
100 1300 2450 09-JUN-91 23-JAN-92 3750
500 5000 5000 17-NOV-91 17-NOV-91 5000
DEP AVG(SALARY) COUNT(*)
--- ----------- ----------
100 1300 1
400 1100 1
500 5000 1
200 3000 2
300 1233.33333 3
DEP AVG(SALARY) COUNT(*)
--- ----------- ----------
400 1100 1
300 1566.66667 6
100 1875 2
200 2443.75 4
500 5000 1
DEP AVG(SALARY)
--- -----------
100 1875
200 2443.75
300 1566.66667
500 5000
DEP AVG(SALARY)
--- -----------
500 5000
200 2443.75
100 1875
300 1566.66667
DEP AVG(SALARY)
--- -----------
100 1875
DEP AVG(SALARY)
--- -----------
500 5000
200 3000
DEPT_NAME AVG(SALARY)
--------------- -----------
Management 5000
Research 3000
DEPT_NAME AVG(SALARY)
--------------- -----------
Management 5000
Research 3000
DEPT_NAME AVG(SALARY)
--------------- -----------
Research 2443.75
Accounting 1875
Sales 1566.66667
DEPT_NAME AVG(SALARY)
--------------- -----------
Research 2443.75
Accounting 1875
Sales 1566.66667
MGR MIN(HIRED
---- ---------
7902 17-DEC-90
7839 02-APR-91
7698 20-FEB-91
COUNT(JOB_TITLE)
----------------
14
COUNT(DISTINCTJOB_TITLE)
------------------------
5
COUNT(JOB_TITLE)
----------------
14
How Many Job-titles
-------------------
5
COUNT(COMMISSION)
-----------------
4
COUNT(DISTINCTCOMMISSION)
-------------------------
4