Question
SQL Anything bold is primary key. no key Constraints have been given Artist( name : string, age: integer) Song( title : string, year : integer,
SQL
Anything bold is primary key.
no key Constraints have been given
Artist(name: string, age: integer)
Song(title: string, year: integer, composer: string)
Performance(artist: string, song: string)
Hits(year: integer, rank: integer, song: string)
A. The name and age of all artists under the age of 17 who have at least one hit.
B. The names of all artists who performed a song composed by David Smith.
C. Every composer who wrote at least two different songs in 1986.
D. The name of every artist who performed a hit with a lower rank than a previous hit (previous means performed in an earlier year).
E. The title of every Song that was never a hit.
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