COMP3311 20T3 The University of New South Wales Database Systems
COMP3311 Database Systems
20T3
[Instructions] [Notes] [Database] [Course Website] [Cheat Sheets]
[Q1] [Q2] [Q3] [Q4] [Q5] [Q6] [Q7] [Q8] [Q9] [Q10] [Q11] [Q12] Question 1 (5 marks)
Write an SQL view that gives the country name of each team and the number of matches it has played.
Instructions:
Work on this question in the work/q1/ directory
Define a view q1(team,nmatches) in the file q1.sql
Also, place any additional views used by q1 in this file
Additional views must be placed before the q1 definition
Load it into your database using: psql footy -f q1.sql Sample output is in the file: tests/01.expected
Test it via: select * from q1 order by team;
Check it using: sh check q1 in the q1 directory
Submit it using: give cs3311 sample_q1 q1.sql or Webcms3
End of Question