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