ITM 500 Lecture Notes - 12012, Data Definition Language
Document Summary
List the id , name ,join date, phone and member type for all members. List the id , name ,join date, phone and member type for all female members. Select memberid, membername, joindate, phone, membertype from member. List the id, name gender and handicap for all members whose handicap least 10 but is no more than 20. -q4 list the details for all members who are female and who also have a barbill under . Where gender = "f" and barbill < . List the details for all members whose type is either senior or junior. Where membertype = "senior" or membertype = "junior" List the details for all members whose type is either junior or senior and who also have a handicap over 20. Where (membertype = "junior" or membertype = "senior") and handicap > 20. Where membertype in ("junior","senior" ) and handicap > 20.