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 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)

Question

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  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)

Accepted Answer

The Answer is in the image, click to view ...

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

Step by Step Solution

Step: 1

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Students explore these related Databases questions