Question

Develop SQL statements to do the following:

Query 1: List all employees by LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_EMP_CITY, LXXX_EMP_PHONE, LXXX_DEP_ID, order by LXXX_DEP_ID.

Query 2: List all employees by LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_DEP_NAME, order by LXXX_DEP_NAME.

Query 3: List all employees by LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_DEP_NAME who work for the "XXX_SALES" department.

Query 4: List all employees by LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_DEP_NAME, LXXX_EMP_CITY, LXXX_DEP_CITY who live and work in the same city, order by LXXX_DEP_CITY

Query 5: List all employees by LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_PROJ_TYPE, LXXX_START_DATE, LXXX_END_DATE who have worked in either an “XXX_CUSTOMER SURVEY” project or an “XXX_CUSTOMER GOLF OUTING” project.

Query 6: List all employees by LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_ROLE_NAME who have worked in the role of an “XXX_PROJECT MANAGER”.

Answer 1

QUERY 1:

  SELECT LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_EMP_CITY, LXXX_EMP_PHONE, LXXX_DEP_ID FROM EMPLOYEE ORDER BY LXXX_DEP_ID ASC;

QUERY 2:

SELECT LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_DEP_N AME FROM EMPLOYEE ORDER BY LXXX_DEP_NAME ASC;
QUERY 3:

SELECT LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_DEP_N AME FROM EMPLOYEE WHERE LXXX_DEP_NAME FROM EMPLOYEE WHERE LXXX_DEP_NAME='XXX_SALES';
QUERY 4:   

SELECT LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_DEP_NAME, LXXX_EMP_CITY, LXXX_DEP_CITY FROM EMPLOYEE WHERE LXXX_EMP_CITY= LXXX_DEP_CITY;

QUERY 5:

  SELECT LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_PROJ_TYPE, LXXX_START_DATE, LXXX_END_DATE FROM EMPLOYEE WHERE PROJ_TYPE='XXX_CUSTOMER SURVER' OR PROJ_TYPE='XXX_CUSTOMER COLF OUTING';

QUERY 6:

  SELECT employees by LXXX_EMP_ID, LXXX_EMP_NAME, LXXX_ROLE_NAME FROM EMPLOYEE WHERE LXXX_ROLE_NAME ='XXX_PROJECT MANAGER';

IF YOU HAVE ANY QUERY PLEASE COMMENT DOWN BELOW

PLEASE GIVE A THUMBS UP