The purpose of this assignment is to demonstrate knowledge of the basic syntax of a SQL query. Specifically, you will be asked to demonstrate:

• use of the SELECT clause to specify which fields you want to query,
• use of the FROM clause to specify which tables you want to query, and
• use of the WHERE clause to specify which conditions the query will use to query rows in a table.

These are the basic commands that will make up your foundational knowledge of SQL. There are other clauses besides SELECT, FROM, and WHERE, but by building up your knowledge of these basic clauses, you will have constructed a foundation upon which to base your knowledge of SQL.

Tasks

1. Design the following queries, using the lyrics.sql schema:

   1. List the Title, UPC and Genre of all CD titles. (Titles table)

   2. List all of the information of CD(s) produced by the artist whose ArtistID is 2. (Titles table)

   3. List the First Name, Last Name, HomePhone and Email address of all members. (Members table)

   4. List the Member ID of all male members. (Members table)

   5. List the Member ID and Country of all members in Canada. (Members table)

   6. List the first name, last name, and region of all members from Virginia who either have a work phone or an email address. (Members Table)

2. Save your queries in a txt file.
3. Click Submit Assignment in the upper right to choose the upload type for your assignment, then click Submit Assignment to complete the submission.

Submission Format

• Please submit your assignment by uploading a .txt file.

Criteria for Success

First and foremost, each query must run properly. Please mind your syntax, and make sure that all queries run properly in MySQL before copying them to your .txt file for submission. You will be graded on whether the queries run properly in MySQL, their SELECT clause, their FROM clause, and their WHERE clause. Check the rubric below to see how you'll be graded for each query. This assingment will be worth 10% of your overall grade for the semester.