CST 1204 Chapter Notes - Chapter 5: Pzl, Item Number, Unit
Document Summary
List the order numbers that contain an order line for an item in category pzl. Q: list the number and name of each customer, together with the number, last name, and first name of the sales rep who represents the customer. Where customer. rep_num = rep. rep_num; // joining with where is inner join. Q: list the number, and name of each customer whose credit limit is ,500, together with the number, last name, and first name of the sales rep who represents the customer. Where customer. rep_num = rep. rep_num and credit_limit = "7500"; Q: for every item on order, list the order number, item number, description, number of units ordered, quoted price, and unit price. Q: find the description of each item included in order number 51623. Q: list the first and last names of all owners who have a three-bedroom condo. Where owner_num in //used in smaller tables; joining takes time (select owner_num.