Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You have been contracted by a small company named DJ's on Demand to create a database for storing information on their jobs, event venues, partners,
You have been contracted by a small company named DJ's on Demand to create a database for storing information on their jobs, event venues, partners, clients, and music catalog.
Assignment Deliverable:
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.
(4 points each, 48 points total)
- 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:
- Inventory Item, CD Title, Music Producer, and Year Purchased
- Write a query to return the title of the oldest recording in the D_CDS table. Your query should return only 1 row.
- Write a query to return the producer information from the D_CDS table for the CD titled "Carpe Diem".
- 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".
- 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started