Using aSelectstatement identify how many total rows exist in the Production.Suppliers table where thecontacttitlevalue begins with 'sales'. (Hint, the answer is not zero).

Using aSelectstatement identify how many total rows exist in the Sales.Customers table where the city is one of the following values, 'Portland', 'Paris', or 'London'.

Using aSelectstatement identify how many total rows exist in the Sales.Customers table where both the region is null and the fax number is null.

Using aSelectstatement identify how many total rows exist in the Sales.Customers table where either the region is null or the fax number is null.

Using aSelectstatement identify how many total rows exist in the Sales.Customers table where the contact's title is 'owner' and the country is either 'usa' or 'mexico'.

From the Sales.Customers table select the phone number and then for the second column select only the area code portion of the phone number and name this column 'AreaCode'. Select only those rows where the country is 'usa'. To produce the area code column you will need to use the SubString() function.

Using aSelectstatement select all rows and columns from the HR.Employees table for employees who were born in the decade of the 1970s.