Question 2 (5 marks)
Write an SQL view that report which group(s) have no albums
(at least not in the database).
Define the view as q2("group"), where the attribute is:
- "group" = the name of a group
Note that the attribute name "group" must appear in
double-quotes because it's an SQL reserved word.
Instructions:
- Work on this question in the work/q2/ directory
- Define the view q2 in the file q2.sql
- Also, place any additional views used by q2 in this file
- You may not define your own functions to help in answering this question
- Additional views must be placed before the q2 definition
- Load it into your database using: psql music -f q2.sql
- Sample output is in the file: tests/01.expected
- Test it via: select * from q2 order by "group";
- Check it using: sh check q2 in the q2 directory
- Submit it using: give cs3311 exam_q2 q2.sql or Webcms3