Explore AdventureWorks Database. Create SQL queries toanswer the questions below.

Functions and Expressions

• Write a query using the Production.Product table displaying theproduct ID, color, and name columns. If the color column contains aNULL value, replace the color with No Color.
• Write a query that displays the first 10 characters of theAddressLine1 column in the Person.Address table.

Inner Joins

• The HumanResources.Employee table does not contain the employeenames. Join that table to the Person.Person table on theBusinessEntityID column. Display the job title, birth date, firstname, and last name.

Subqueries

• Using a subquery, display the product names and product IDnumbers from the Production.Product table that have beenordered.