You have a database table named SongInformation as defined below:
You need to create a Structured Query Language (SQL) query to retrieve only the names of songs
that sold more than 1000 compact discs (CDs).
Which query should you use?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
“… only the names of songs
that sold more than 1000 compact discs (CDs) ”
The correct answer should be “Option A”
11
0
correct answer must be “Option A” according to given question
only the names of songs
that sold more than 1000 compact discs (CDs).
5
0
yes option A is the answer, it is not asking for all columns to retrieve, only asking song name, needs to correct it or provide the explanation with source
2
0
Its A indeed. Awnser D returns EVERYTHING, and that’s not wat is asked.
2
0
A
1
0