MUHAMMAD MU�IZUDDIN BIN HJ MUHSINONSN097083

LAB 1 - DATABASE EXERCISE

-> ANSWER QUESTION 1

DESCRIBE DEPARTMENTS;

SELECT * FROM departments;

-> ANSWER QUESTION 2

SELECT * FROM employees;

-> ANSWER QUESTION 3

SELECT EMPLOYEE_ID, LAST_NAME, JOB_ID, HIRE_DATE "STARTDATE"FROM employees;

-> ANSWER QUESTION 4

SELECT JOB_IDFROM EMPLOYEES;

-> ANSWER QUESTION 5

SELECT EMPLOYEE_ID "Emp#", LAST_NAME "Employee", JOB_ID "Job", HIRE_DATE FROM employees;

-> ANSWER QUESTION 6

SELECT LAST_NAME || ' , ' || JOB_ID AS "Employee and Title"FROM employees;

-> ANSWER QUESTION 7

SELECT EMPLOYEE_ID || ',' || FIRST_NAME || ',' || LAST_NAME || ',' || EMAIL || ',' || PHONE_NUMBER || ',' || HIRE_DATE || ',' || JOB_ID || ',' || SALARY || ',' || COMMISSION_PCT || ',' || MANAGER_ID || ',' || DEPARTMENT_ID AS "THE_OUTPUT"FROM EMPLOYEES;