In Table 7-1, your users need an easy way to display only the first name, last name, and phone number for customers in the 222 area code. What should you have them do?

In Table 7-1, your users need an easy way to display only the first name, last name, and phone number for customers in the 222 area code. What should you have them do?

In Table 7-1, your users need an easy way to display only the first name, last name, and phone number for customers in the 222 area code. What should you have them do?


Answer – Create a view based on the table using this query:
SELECT firstname, lastname, phone FROM customers
WHERE phone like ‘222%’
Then have users query the view.

(It is much faster for the users to query a view in this case because there is less code. You do not want to use the SELECT * statement because that returns all fields from the table, and you need only FirstName, LastName, and Phone.)