ITM 500 Study Guide - Mixed-Member Proportional Representation

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 500
• Professor: Raymond Moss

Document Summary

-1 list the details for each tournament that has had at least 3 entries. -in 2006 select * from tournament where tourid in (select tourid from entry where year = 2006 group by tourid having count(*) >= 3) -2 list the details for senior members whose barbill is the above average for their membership type select * from member where membertype = "senior" and barbill > (select avg(barbill) from member where membertype = "senior") -3 list the id and names of all members who played any tournament after the year 2005. -(use a nested approach) select memberid, membername from member where memberid in (select memberid from entry where year > 2004) -4 repeat query 3 above but use a join. Only show each member"s details once select distinct m. memberid ,membername from member m inner join entry e on e. memberid = m. memberid where year > 2004. List the details of members who are coached by a member of teamb.