Question: 1 find the last names of all members who live...
1. Find the last names of all members who live in California with the names of all studios that are located in California in a single list. (1 column, multiple rows)
2. Find the memberID and birthday of every member in Vermont (VT) who is older than all the members from NY.
3. Find the trackTitles of all tracks recorded by artists which
were entered into the database (that is, have entrydates) after
August 1, 2003. Use one or more joins;
do not use any subqueries.
4. Find the same data selected in the last question. This time, use one or more subqueries and do *not* use any joins.
5. Show the name of each artist which has recorded at least one title at a studio where The Bullets have recorded (Including The Bullets). Use subqueries, not joins.