Question: 6. List all authors whose last name contains the letter pattern IN. Put the results in order of last name, then first name. List each
6. List all authors whose last name contains the letter pattern "IN." Put the results in order of last name, then first name. List each author's last name and first name. 7. List all customers who were referred to the bookstore by another customer. List each customer's last name and the number of the customer who made the referral. 8. Display the book title and category for all books in the Children and Cooking categories. Create three different queries to accomplish this task: a) a search pattern operation, b) a logical operator, and c) another operator not used in a or b. 9. Use a search pattern to find any book title with "A" for the second letter and "N" for the fourth letter. List each book's ISBN and title. Sort the list by title in descending order. 10. List the title and publish date of any computer book published in 2005. Perform the task of searching for the publish date by using three different methods: a) a range operator, b) a logical operator, and c) a search pattern operation. 6. List all authors whose last name contains the letter pattern "IN." Put the results in order of last name, then first name. List each author's last name and first name. 7. List all customers who were referred to the bookstore by another customer. List each customer's last name and the number of the customer who made the referral. 8. Display the book title and category for all books in the Children and Cooking categories. Create three different queries to accomplish this task: a) a search pattern operation, b) a logical operator, and c) another operator not used in a or b. 9. Use a search pattern to find any book title with "A" for the second letter and "N" for the fourth letter. List each book's ISBN and title. Sort the list by title in descending order. 10. List the title and publish date of any computer book published in 2005. Perform the task of searching for the publish date by using three different methods: a) a range operator, b) a logical operator, and c) a search pattern operation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
