open Adventurework2014 database as your default database. Do not forget to use the SQL standards.

1. Query full names (Title, First name, middle name and last name) and email address for all persons. (You need to manage NULL values while concatenating the name parts).

USING: Person.Person Person.EmailAddress

2. Query the products that are NOT in the Inventory. Use alias for the tables

USING: Production.Product Production.ProductInventory

3. Write a query to show products ( product ID, product name ) with a special offer.

USING: Production.Product SpecialOfferProduct

4. Write a query to show products with same rating.

USING: Production.ProductReview