Write SQL statements to do the following: Find a list of all information on Electronica CDs
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: