1. Write a query to a list of all the DJ's on Demand CD title and producer name that were produced in either the year 2000 or 2004.
2. The manager of DJ's on Demand would like to know the partners (first name, last name) who do NOT have an authorized expense amount, order the output by first name.

DJs on Demand Table Design DLPLAY LIST ITEMS PF. EVENT_ID NUMBER PF BONORD NUMBER SOMMENTE VARGILARRO DPUMPKEVENT_JD. SONO_) D_PUM EVENTLID_FK (EVENT_JD) D_PLUSONG_10_JK(SONO_ID) 0_00_ASSIGNMENTS PARTNIKLID NUMPER () F EVENTLID NUMDER JOG DATE DATE STATUS VARCHARZ 000) DJATUPK (PARTNERUD. EVENTUD) D_JAT EVENTLID FK LEVENTUD) HAT PARTNERID FK PARTNERUD) W DLPARTNERS UMID NUMBER) FIRST NAME VARCHAR2 23 LAST NAME VARCHAR20) EXPERTISE VARCHAR2 (20) OTCOIALTY VARCIANES AUTH_EXPENSELAMTI MUWBER 2) MANADERUD NUVEER C PARTNER TYPE VARCHAR2 (5 D_PTRUD PK (D) D THEMES P CODE HUMBER (10) DESCRIPTION VARCHAR2 (100) D_THE_CODE_PK (CODE) SONGS PID NUMBER (5) - TITLE VARCHARD (30) DURATION VARCHARD (20) MATIT VARGHANZ ZD) - TYPE_COPE NVMBER 12 D_SNG_ID_PK (D) D_SNG_TYPE_CODE_FK (TYPE_CODE) DPACKAGES DL EVENTS ID NUMBER (5) BAR NAME VARCHAR2 801 EVENT DATE DATE DESCRIPTION VARCHAR2(50) COST NUMBER 09.21 HAVENUSLID WUUDBAN PACKADE CODE NUMBLM10) THEME_CODE NUMBER (10) " CUENT NUMBER NUNWER PLEVELD_PK (ID) D_EVE_CLIENTLMUWDERLEK (CLIENT NUMBER LEVEL PACKAGE CODEL FK (PACKAGEICODE) D_EVE_THEMELCODELFK (THEME_CODE) D_EVE VENUE JD_FK (VENUE JD) CODE NUMBER (10) LOW_RANGE NUMBER (0) - HIGH_RANGE NUMBER (0) DUPKE_CODE_PK (CODE) D_TRACK_LISTINGS PF SONG NUMBER PF CD_NUMBER NUMBER (0) TRACK NUMBER (2) O TYPESIALISTER CODE NUMBER (10) DESCRIPTION VARCHAR(10) > DUTPE_CODE_PK (CODE) >D_TLG_PK (SONG_ID.CD_NUMBER) D_TLG_CD_NUMBER_FK(CD_NUMBER) D_TLG_SONG_ID_FK (SONG_ID) SONG ID IDX ISONG 10 DIVENUES PID NUMBER (0) LOC_TYPE VARCHAR2 (30) ADDRESS VARCHAR2 (100) RENTAL FEE VARCHAR2 (50) COMMENTS VARCHAR2(100) DIVNE_ID PKD) D_CDS PCD_NUMBER NUMBER TITLE YANGHAME (29) PRODUCER VARCHAR2(00) YEAR VARCHAR2 (4) > D_CDS_CD_NUMBER_PK (CD_NUMBER) D_CDS_IDX (TITLE) D_CLIENTS PEL CLIENT NUMBER NUMER 152 lika I_NAME WARGA ) LAST_NAME VARCHARZ 00) PHONE NUMBER (15) EMAIL VARCHAR2(60) D_CLT_CLIENT_NUMBER_PK (CLIENT NUMBER)