ITM 500 Lecture Notes - 12012, Data Definition Language

252 views10 pages

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.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers