Lab2

--Select DISTINCT LAST_NAME, ADDRESS, CITY, STATE, ZIP  FROM F_CUSTOMERS; 
--Select '***'|| FIRST_NAME ||'***'|| FIRST_NAME ||'***'AS "SUPER STAR" FROM F_STAFFS
--Select LAST_NAME, SALARY, SALARY*1.05  FROM EMPLOYEES
--Select CD_NUMBER ||''||TITLE AS"CD TITLE", PRODUCER AS"MUSIC PRODUCER", YEAR AS"YEAR PURCHASED", CD_NUMBER AS"INVENTORY ITEM"  FROM D_CDS 
--Select FIRST_NAME, LAST_NAME, ADDRESS FROM F_CUSTOMERS WHERE ID = 456
--Select NAME, START_DATE, END_DATE FROM F_PROMOTIONAL_MENUS WHERE GIVE_AWAY ='ballpen and highlighter'
--Select TITLE, YEAR FROM D_CDS WHERE YEAR <> 2000
--Select FIRST_NAME, LAST_NAME FROM F_STAFFS WHERE BIRTHDATE < '01-Jan-1980'
--Select FIRST_NAME, LAST_NAME, SALARY FROM F_STAFFS WHERE SALARY BETWEEN 5 AND 10
--Select TITLE FROM D_CDS WHERE TITLE LIKE '_a%'
--Select FIRST_NAME, LAST_NAME FROM D_PARTNERS WHERE AUTH_EXPENSE_AMT IS NULL
--Select EMPLOYEE_ID, LAST_NAME, EMAIL, FIRST_NAME, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID, BONUS  FROM EMPLOYEES WHERE LAST_NAME LIKE '%s'
--Select TITLE FROM D_SONGS WHERE TYPE_CODE IN ('77', '12', '1')
--Select LAST_NAME FROM EMPLOYEES WHERE LAST_NAME LIKE '