Critical Thinking Questions (Multiple Choice) Based on the Following Query

Multiple Choice

Critical Thinking questions (Multiple Choice) Based on the following query: SELECT AlbumTitle FROM Albums WHERE ArtistName = 'Jefferson Airplane' AND DiscountPrice

A) if the ArtistName field contains Jefferson Airplane
B) if the value in the DiscountPrice field is less than $10.00
C) if the ArtistName field contains Jefferson Airplane and the value in the DiscountPrice field is less than $10.00
D) if the ArtistTitle field contains Jefferson Airplane and the value in the DiscountPrice field is less than $10.00