Which query should you use?

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?

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



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Peter Smith

Peter Smith

“… only the names of songs
that sold more than 1000 compact discs (CDs) ”

The correct answer should be “Option A”

pawan Chhangani

pawan Chhangani

correct answer must be “Option A” according to given question

only the names of songs
that sold more than 1000 compact discs (CDs).

jaspreet

jaspreet

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

Ivo

Ivo

Its A indeed. Awnser D returns EVERYTHING, and that’s not wat is asked.

Ardalan Shahgholi

Ardalan Shahgholi

A