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.