drmopco
asked on
SQL Query
Dear experts.
I try to calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees. Can you tell me what did I wrong??
I got the error that Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'FROM'.
Here is my code
SELECT MAX(SALARY),
FROM EMPLOYEES,JOB_TITLE,
WHERE EXEMPT_STAUTS=NON_EXEMPT_S TAUTS;
CREATE TABLE EMPLOYEES
(EMPLOYEES_NUM CHAR(2) PRIMARY KEY,
LAST_NAME CHAR(15),
FIRST_NAME CHAR(15),
ADDRESS CHAR(50),
CITY CHAR(15),
STATE CHAR(2),
TELEPHONE_AREA_CODE CHAR(3),
TELEPHONE_NUMBER CHAR(7),
EEO_1CLASSIFICATION CHAR(50),
HIRE_DATE CHAR(8),
SALARY DECIMAL(8,2),
GENDER CHAR(1),
RACE CHAR(30),
AGE CHAR(2));
The command(s)completed successfully.
Data insertion
INSERT INTO EMPLOYEES
VALUES
('01','EDELMAN','GLENN','1 75 BISHOPS LANE','LA
JOLLA','CA','619','5550199 ',
'SALES WORKERS','20061007','21500 .00','F',' CAUCASIAN' ,'64');
INSERT INTO EMPLOYEES
VALUES
(
'02','MCMULLEN','ERIC','76 3 CHURCH ST','LEMON
GROVE','CA','619','5550133 ',
'SALES WORKERS','20021101','13500 .00','M',' CAUCASIAN' ,'20');
INSERT INTO EMPLOYEES
VALUES
(
'03','SLENTZ','RAY','123 TORREY DR','NORTH CLAIRMONT','CA','619',
'5550123','OPERATIVES','19 980715','2 3500.00',' F','HISPAN IC','28');
INSERT INTO EMPLOYEES
VALUES
(
'04','BROUN','ERIN','2045 PARKWAY APT213','ENCINITAS',
'CA','760','5550100','SALE S
WORKERS','20030312','10530 .00','F',' CAUCASIAN' ,'24');
INSERT INTO EMPLOYEES
VALUES
(
'05','CARPENTER','DONALD', '927 SECOND
ST','ENCINITAS','CA','619' ,'5550154' ,
'OFFICE/CLERICAL','2003021 8','15000. 00','M','A FRICAN-AME RICAN','18 ');
INSERT INTO EMPLOYEES
VALUES
(
'06','ESQUIVEZ','DAVID','1 0983 N.COAST HWY
APT902','ENCINITAS','CA',' 760','5550 108',
'OPERATIVES(SEMI-SKILLED)' ,'20030725 ','18500', 'M','HISPA NIC','25') ;
INSERT INTO EMPLOYEES
VALUES
(
'07','SHARP','NANCY','1079 3 MONTCANO RD','RAMONA','CA','858','5 550135',
'SALES WORKERS','20030712','21000 .00','F',' CAUCASIAN' ,'24');
INSERT INTO EMPLOYEES
VALUES
(
'08',
'MCNAMARA',
'JUANITA',
'923 PARKWAY',
'POWAY',
'CA',
'619',
'5550206',
'OFFICE/CLERIACAL',
'19991029',
'25500.00',
'F',
'HISPANIC',
'32');
INSERT INTO EMPLOYEES
VALUES
(
'09',
'NGUYEN',
'MEREDITY',
'10583 ARENAS ST',
'LA JOLLA',
'CA',
'619',
'5550102',
'TECHNIICAN',
'19980927',
'43000.00',
'M',
'CAUCASIAN',
'25');
INSERT INTO EMPLOYEES
VALUES
(
'10',
'STEPHENS',
'HARVERY',
'7863 HIGH BLUFF DRIVE',
'LA JOLLA',
'CA',
'619',
'5550123',
'OFFICE&MANAGERS',
'19980301',
'75000.00',
'M',
'CAUCASIAN',
'51');
INSERT INTO EMPLOYEES
VALUES
(
'11',
'VU',
'MATTHEW',
'981 JOVEY PINES ROAD',
'LA JOLLA',
'CA',
'619',
'5550138',
'TECHNICIAN',
'20000816',
'37000.00',
'M',
'ASIAN',
'26');
INSERT INTO EMPLOYEES
VALUES
(
'12',
'AVERY',
'LEDONNA',
'198 HAVERNA DR',
'DELMAR',
'CA',
'619',
'5550135',
'CRAFT WORKERS(SKILLED)',
'20030328',
'21000.00',
'F',
'AFRICAN-AMERICAN',
'23');
INSERT INTO EMPLOYEES
VALUES
(
'13',
'DROHOS',
'CRAIG',
'X',
'SOLANO BEACH',
'CA',
'619',
'5550202',
'OFFICALS & MANAGERS',
'20000615',
'51000.00',
'M',
'CAUCASIAN',
'28');
INSERT INTO EMPLOYEES
VALUES
(
'14',
'MEIER',
'ELAINE',
'9703 DRAVIE LANE',
'DEMAR',
'CA',
'858',
'5550112',
'SALES WORKERS',
'20000910',
'20500.00',
'F',
'ASIAN',
'51');
INSERT INTO EMPLOYEES
VALUES
(
'15',
'QUILLIAN',
'STANLEY',
'98542 WANDERING ROAD APT2-B',
'DELMAR',
'CA',
'760',
'5550198',
'OPERATIVES(SEMI-SKILLED)' ,
'19991216',
'23000.00',
'M',
'AMERIAN-INDIAN',
'29');
INSERT INTO EMPLOYEES
VALUES
(
'16',
'TYINK',
'THOMAS',
'87592 VACIFIC HEIGHTS BLVD',
'DELMAR',
'CA',
'858',
'5550159',
'CRAFT WORKERS(SKILLED)',
'20010501',
'19000.00',
'M',
'AFRICAN-AMERICAN',
'32');
INSERT INTO EMPLOYEES
VALUES
(
'17',
'VANCE',
'BRENT',
'927 CYUTHIA LANE',
'POWAY',
'CA',
'858',
'5550147',
'SALES WORKERS',
'20010329',
'10530.00',
'M',
'CAUCASIAN',
'22');
I try to calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees. Can you tell me what did I wrong??
I got the error that Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'FROM'.
Here is my code
SELECT MAX(SALARY),
FROM EMPLOYEES,JOB_TITLE,
WHERE EXEMPT_STAUTS=NON_EXEMPT_S
CREATE TABLE EMPLOYEES
(EMPLOYEES_NUM CHAR(2) PRIMARY KEY,
LAST_NAME CHAR(15),
FIRST_NAME CHAR(15),
ADDRESS CHAR(50),
CITY CHAR(15),
STATE CHAR(2),
TELEPHONE_AREA_CODE CHAR(3),
TELEPHONE_NUMBER CHAR(7),
EEO_1CLASSIFICATION CHAR(50),
HIRE_DATE CHAR(8),
SALARY DECIMAL(8,2),
GENDER CHAR(1),
RACE CHAR(30),
AGE CHAR(2));
The command(s)completed successfully.
Data insertion
INSERT INTO EMPLOYEES
VALUES
('01','EDELMAN','GLENN','1
JOLLA','CA','619','5550199
'SALES WORKERS','20061007','21500
INSERT INTO EMPLOYEES
VALUES
(
'02','MCMULLEN','ERIC','76
GROVE','CA','619','5550133
'SALES WORKERS','20021101','13500
INSERT INTO EMPLOYEES
VALUES
(
'03','SLENTZ','RAY','123 TORREY DR','NORTH CLAIRMONT','CA','619',
'5550123','OPERATIVES','19
INSERT INTO EMPLOYEES
VALUES
(
'04','BROUN','ERIN','2045 PARKWAY APT213','ENCINITAS',
'CA','760','5550100','SALE
WORKERS','20030312','10530
INSERT INTO EMPLOYEES
VALUES
(
'05','CARPENTER','DONALD',
ST','ENCINITAS','CA','619'
'OFFICE/CLERICAL','2003021
INSERT INTO EMPLOYEES
VALUES
(
'06','ESQUIVEZ','DAVID','1
APT902','ENCINITAS','CA','
'OPERATIVES(SEMI-SKILLED)'
INSERT INTO EMPLOYEES
VALUES
(
'07','SHARP','NANCY','1079
'SALES WORKERS','20030712','21000
INSERT INTO EMPLOYEES
VALUES
(
'08',
'MCNAMARA',
'JUANITA',
'923 PARKWAY',
'POWAY',
'CA',
'619',
'5550206',
'OFFICE/CLERIACAL',
'19991029',
'25500.00',
'F',
'HISPANIC',
'32');
INSERT INTO EMPLOYEES
VALUES
(
'09',
'NGUYEN',
'MEREDITY',
'10583 ARENAS ST',
'LA JOLLA',
'CA',
'619',
'5550102',
'TECHNIICAN',
'19980927',
'43000.00',
'M',
'CAUCASIAN',
'25');
INSERT INTO EMPLOYEES
VALUES
(
'10',
'STEPHENS',
'HARVERY',
'7863 HIGH BLUFF DRIVE',
'LA JOLLA',
'CA',
'619',
'5550123',
'OFFICE&MANAGERS',
'19980301',
'75000.00',
'M',
'CAUCASIAN',
'51');
INSERT INTO EMPLOYEES
VALUES
(
'11',
'VU',
'MATTHEW',
'981 JOVEY PINES ROAD',
'LA JOLLA',
'CA',
'619',
'5550138',
'TECHNICIAN',
'20000816',
'37000.00',
'M',
'ASIAN',
'26');
INSERT INTO EMPLOYEES
VALUES
(
'12',
'AVERY',
'LEDONNA',
'198 HAVERNA DR',
'DELMAR',
'CA',
'619',
'5550135',
'CRAFT WORKERS(SKILLED)',
'20030328',
'21000.00',
'F',
'AFRICAN-AMERICAN',
'23');
INSERT INTO EMPLOYEES
VALUES
(
'13',
'DROHOS',
'CRAIG',
'X',
'SOLANO BEACH',
'CA',
'619',
'5550202',
'OFFICALS & MANAGERS',
'20000615',
'51000.00',
'M',
'CAUCASIAN',
'28');
INSERT INTO EMPLOYEES
VALUES
(
'14',
'MEIER',
'ELAINE',
'9703 DRAVIE LANE',
'DEMAR',
'CA',
'858',
'5550112',
'SALES WORKERS',
'20000910',
'20500.00',
'F',
'ASIAN',
'51');
INSERT INTO EMPLOYEES
VALUES
(
'15',
'QUILLIAN',
'STANLEY',
'98542 WANDERING ROAD APT2-B',
'DELMAR',
'CA',
'760',
'5550198',
'OPERATIVES(SEMI-SKILLED)'
'19991216',
'23000.00',
'M',
'AMERIAN-INDIAN',
'29');
INSERT INTO EMPLOYEES
VALUES
(
'16',
'TYINK',
'THOMAS',
'87592 VACIFIC HEIGHTS BLVD',
'DELMAR',
'CA',
'858',
'5550159',
'CRAFT WORKERS(SKILLED)',
'20010501',
'19000.00',
'M',
'AFRICAN-AMERICAN',
'32');
INSERT INTO EMPLOYEES
VALUES
(
'17',
'VANCE',
'BRENT',
'927 CYUTHIA LANE',
'POWAY',
'CA',
'858',
'5550147',
'SALES WORKERS',
'20010329',
'10530.00',
'M',
'CAUCASIAN',
'22');
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANKS. IT HELPS A LOT!!!!
Thanks - glad it helped.
ASKER
I got the maximum salary for exempt employees but I don't know how to get the salary for non_exempt employees.
Here is my update one.
SELECT MAX(SALARY),
FROM EMPLOYEES,JOB_TITLE,
WHERE EXEMPT_NON_EXEMPT_=EXEMPT_