# 1. For every row in the Awards table, list the award name, the names of every 
project and group nominated for that award, ORDERed by the award name.  
(Regardless of which entity you used in the Nominations table, list both project 
and group.)

SELECT a.aw_name, g.name, p.name
FROM award a, nomination n, music_group g, project p
WHERE a.aw_id=n.aw_id
  AND n.nominee=g.group_id
  AND g.group_id=p.group_id
ORDER BY a.aw_name;


# 2. List each Award name and a COUNT of how many nominees there are for each.

SELECT a.aw_name, count(*)
FROM award a NATURAL JOIN nomination n
GROUP BY a.aw_name;


# 3. List the names and current projects of all solo performers (make sure there 
is at least one solo performer in your database).

SELECT g.name, p.name
FROM music_group g, project p
WHERE g.group_id = p.group_id
  AND g.group_id IN ( SELECT group_id
                      FROM musician
                      GROUP BY group_id
                      HAVING count(group_id) = 1 ) ;