ITM 500 : ITM500 - LAB 2 SOLUTION.doc

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

Document Summary

List the id , name and member type for all members select memberid, membername, membertype from member. List the id , name and member type for all junior members select memberid, membername, membertype from member where membertype = "junior" List the id, name and bar bill for all members whose bar bill is at least but is no more than select memberid, membername, barbill from member where barbill >= 60 and barbill <= 90. - or select memberid, membername, barbill from member where barbill between 60 and 90. -q4 list the details for all members who are junior and who also have a handicap under 25 select * from member where membertype = "junior" and handicap < 25. List the details for all members whose type is either social or junior select * from member where membertype = "social" or membertype = "junior" -or select * from member where membertype in ("social", "junior" )