Create separate select statements to query data to answer each question. Be sure to place a single-line comment before each question to identify the question being answered.

1. The owners of DJ's on Demand would like a query that returns of all items in their D_CDs table with the following column headings:
   1. Inventory Item, CD Title, Music Producer, and Year Purchased
2. Write a query to return the title of the oldest recording in the D_CDS table. Your query should return only 1 row.
3. Write a query to return the producer information from the D_CDS table for the CD titled "Carpe Diem".
4. The manager of DJ's on Demand would like a query of all the CD titles and years of CD's that were produced by "Old Town Records".
5. Write a query that will list the titles and years of all the DJ's on Demand's CD's that were NOT produced in the year 2000.
6. Write a query to display the location type and comments for all DJ's on Demand venues that are "Private Home".
7. Write a query to a list of all information for DJ's On Demand track listings for CD Number 91.
8. The manager of DJ's on Demand would like a list of partners (first name, last name), order the output by last name.
9. Write a query that lists the titles of songs in the DJ's on Demand inventory that are type code 77, 12, or 1; order by title.
10. Write a query that will return all the DJ's on Demand CD information (title, year) ordered by year and title.
11. Write a query to list the DJ's on Demand songs ordered (descending) by title. Use the alias "Our Collection" for the song title.
12. Write a query to return a DISTINCT list of producers for the CD's DJ's on Demand has in their collection.

DJs on Demand Table Design D. PLAYLIST ITEMS PF EVENT ID NUMBER) pro SONOLID NUMBER (5) COMMENTS VARCHAR2 (20) D_PLM_PK (EVENT_ID. SONS_ID) D_PLMLEVENT_JD_FK (EVENT_JD) SD_PLMU SONO_JOJK (SONO_10) D_JOU ASSIGNMENTS P PARTNER JO NUMBER) P EVENT 10 NUMBER (15) JOB DATE DATE STATUS VARCHAR(50) D_JAT_PK (PARTNER_ID, EVENT_10) D_JAT_EVENT_JD FK (EVENT_JD) D_JAT_PARTNER_ID_FK (PARTNER_30) D_PARTNERS HUMBER) FIRST_MAME VARCHARG) LAST_NAME VARCHAR10) EXPERTISE VARCHARD SPECIALTY VARCHAR25 AUTH EXPENSEAMT NUMBER 020 MANAGERUD NUMBER) PARTNER_TYPE VARCHAR2 (20) D_PTR_JD_PK (10) D THEMES CODE NUMBER (10) DESCRIPTION VARCHAR2(100) D.TME_CODE_PK (CODE) D SONGS IPID NUMBER) TITLE VARCHAR2(50) DURATION VARCHAR2 (20) ARTIST VARCHAR2 ) TYPE_CODE NUMBER (100 - 6 N H PH c) D_5NG_TYPE_CODE_FK (TYPE_CODE) D EVENTS " ID NUMBER * NAME VARCHAR250) EVENT_DATE DATE DESCRIPTION VARCHAR250) - COST NUMBER) VENUE_ID NUMBER (5) F PACKAGE CODE NUMBER (10) F. THEME_CODE NUMBER (10) FCUENT NUMBER NUMBER -D_EVE_ID_PK (ID) D EVE_CLIENT_NUMBER_FK CLIENT_NUMBER) DEVE_PACKADE_CODE FK (PACKAGE_CODE) D_VE_THEME_CODE FK (THEMECODE) DEVE VENUE_ID_FK (VENUE_ID) D_PACKAGES CODE NUMBER (10) LOW RANDE NUMBER HIOH_RANGE NUMBER) DUPKE_CODE_PK (CODE) DTRACK LISTINGS SONO 10 NUMBER) PF CD NUMBER NUMBER TRACK NUMBER D_TO_PK (DONO_10.CD_NUMBER) DTLO,CD NUMBER JK(CD_NUMBER) SD_TO_SONG_ID (SONO 10) SONOIDJDA SONO_10) D TYPES - CODE NUMBER (10) DESCRIPTION VARCHAR(50 DTPE_CODE_PK (CODE) VENUES NUMBER(S) LOC_TYPE VARCHAR2010 ADORES VARCHAR(100) RENTALFIE VARCHARD 80 COMMENTS VARCHAR(100) - OVNE_10_PK (10) COS CD NUMBER MER TITLE VARHARD PRODUCER HAPA YEAR VARCHARD DLCOS.CD_NUMBER PKD NUMBER COSIDS TITLE) D. CLIENTS GUCNTNUMBER NUVCHI FIRST 05 LASTE VARCHAR200 EMAIL VARCHARE DELT OLENNUVERPCUENTER