*Please write out the queries that would be entered into a SQL Server*

Complete the queries listed below in SQL Server. Use AdventureWorks2014 database to work on the assignment. When creating a

Complete the queries listed below in SQL Server. Use AdventureWorks2014 database to work on the assignment. When creating a new query, dont forget to run (execute) the following statement first so set the current database:

use AdventureWorks2014;

Save your work as queries3.sql and submit the file in D2L. Do not submit any other files. I will use the submitted file to run your code.

6.1. Write a SQL statement that retrieves product ID (ProductID) and name (Name) from Production.Product table for all products containing the phrase "frame" in their name.

6.2. Repeat 6.1, except that now you want to list all product which name does not include the phrase "frame".

6.3. Write a SQL statement that retrieves product ID (ProductID) and name (Name) from Production.Product table for all product whose name includes both the words "silver" and "frame".

6.4. Now, let's step up our game a little bit. From Production.ProductDescription list product description ID (ProductDescriptionID) and description (Description) for all records where both the words "bike" and "road" appear in product descriptions in that particular order (i.e., "bike" before "road"). Hint:the output should include 2 records.

6.5. Write a SQL statement that retrieves first and last names (FirstName, LastName) from Person.Person table, only for those individuals whose first name is either Lewis, Louis, or Luis. Use the LIKE operator. Sort the output alphabetically by last name and by first name.