Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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: I. List the Title, UPC and Genre of all CD titles. (Titles table) II. List all of the information of CD(s) produced by the artist whose ArtistID is 2. (Titles table) III. List the First Name, Last Name, HomePhone and Email address of all members. (Members table) IV. List the Member ID of all male members. (Members table) V. List the Member ID and Country of all members in Canada. (Members table) VI. 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started