Homework 1

Purpose

Purpose

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

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

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

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

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

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

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

• 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)