100%(2)2 out of 2 people found this document helpful
This preview shows page 1 - 3 out of 3 pages.
Anel CoralicCIST 12204/15/2020Lab 13Hands-On Assignments1.Create a view that lists the name and phone number of the contact person at each publisher. Don’t include the publisher’s ID in the view. Name the view CONTACT.Input: Output:2.3.Create a view called HOMEWORK13 that includes the columns name Col1 and Col2 from the FIRSTATTEMPT table. Make sure the view created even if the FIRSTATTEMPT table doesn’t exist.Input: Output:4.
Anel CoralicCIST 12204/15/2020Lab 135.Create a view that lists the ISBN and title for each book in inventory along with the name and