You are going to write a SQL Statement for a Database:
That has 1 table called - Music -
The Music table has 20 records each with 6 fields
The Fields are: Title, Artist, Tracks, Cost, Genre, Inventory
Your Statement:
Write a SQL Select Statement that:
Returns all the records from the database that:
Are in the Genre of Rock AND
You have in stock (Hint: Inventory would have to be atleast 1)
Save your SQL Statement in a Notepad document and email it to me as an Attachment.
Use " Database Assignment - SQL" for the Subject line. Remember to identify
yourself by name and class in the email body.