ITM500 - LAB 2 SOLUTION.doc

2 Pages
133 Views
Unlock Document

Department
Information Technology Management
Course
ITM 500
Professor
Raymond Moss
Semester
Winter

Description
--Lab 2 --Use the GolfClub Database. --Q1. --Q1. List the id , name and member type for all members select MemberId, MemberName, MemberType from Member --Q2. List the id , name and member type for all junior members select MemberId, MemberName, MemberType from Member where MemberType = 'Junior' --Q3. List the id, name and bar bill for all members whose bar bill is at least $60 but is no more than $90 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 --Q5. 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' ) --Q6. List the details for all members whose type is either Junior or Senior and who also have a handicap less than 25 select * from member where (membertype = 'junior' or membertype = 'senior') and handicap < 25 --or select * from Member where MemberType i
More Less

Related notes for ITM 500

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit