Write SQL statements to do the following:

  Find a list of all information on Electronica CDs [Output 5]

  Find a list of the titles of all CDs that cost less than 10.00 [Output 6]

  Find a list of CD titles and prices where the title contains a space [Output 7] 

More complex conditions can be created using the operators AND, OR and NOT. Brackets can be used to control the order of evaluation. For example:

 SELECT * FROM CD WHERE (cdPrice < 10.00) AND NOT (cdGenre=’Rock’);

 Will return a list of CDs that cost less than 10.00, but are not Rock CDs

Answer rating: 100% (QA)

1 SELECT cdtitleprice where cdtitle li... View the full answer