by Sharon Tuttle ================= Problem 2 part a ================= PUB_NAME PU ------------------------------ -- Addison-Wesley MA Benjamin/Cummings CA Irwin IL MacMillan NJ McGraw-Hill NY Merrill OH PWS MA Prentice Hall NJ Science Research Associates CA 9 rows selected. ================= Problem 2 part b ================= TITLE_NAME QTY_ON_HAND ----------------------------------- ----------- Problem Solving and Structures 12 An Introduction to Database Systems 10 Operating Systems: A Systems Approa 5 Building Expert Systems 3 ================= Problem 2 part c ================= PUB_NAME #TITLES ------------------------------ ---------- Benjamin/Cummings 5 Addison-Wesley 4 Prentice Hall 3 PWS 2 McGraw-Hill 2 MacMillan 1 Irwin 1 Science Research Associates 1 8 rows selected. ================= Problem 2 part d ================= TITLE_NAME ORDER_QTY ----------------------------------- ---------- An Introduction to Database Systems 12 Problem Solving and Structures 15 ================= Problem 2 part e ================= PUB_NAME ------------------------------ McGraw-Hill