*I need Questions 4-6 please. Also I have an error for number 2, so please take a look if you dont mind. Thank you*

*My Error for number 2*

*Again any help is greatly appreciated*

sing the Northwind Database, create the following MySQL queries. 1. List the CustomerID, CompanyName and complete address for all customers that have a CustomerID that starts with the letter J,K,L,M or N. Concatenate the customer's Address, City, Region, PostalCode, and Country in one column named "Complete Address". Ensure to add spaces between each one. Sort the list in alphabetical order by CompanyName. (Hints: Since the Region and PostalCode columns used in the complete address may have a Null value, you must use the IFNULL function for these columns. Use a replacement value of an empty string. If you do not, the result of the CONCAT function will be Null. See pages 286-287 in textbook. Also, see the use of the REGEXP operator on pages 100-101.) Here is an example of using the IFNULL function with the CONCAT function. In this example if SampleColumn is Null, the IFNULL function will return as space: CONCAT(IFNULL(SampleColumn, '"), "', AnotbenColumn) 2. List each HOURLY employee's first and last name and their estimated yearly salary. Use 2080 as the number of hours worked annually. Concatenate the employee last and first names separated by a comma. Name the columns appropriately. Display the Yearly Salary with zero decimal places. Sort in alphabetical order by LastName. (Hint. This query will require the use of two tables.) 3. List the ten ProductNames with the highest inventory values (UnitPrice x UnitsInStock). Name the columns "Products" and "Inventory Value". Round the inventory values to two decimal places. (Hint: When referring to column aliases in the ORDER BY clause, use tick marks instead of quotation marks.) 4. List all customers with no fax number on record. Include the CompanyName, ContactName, Country and Phone. ORDER BY Country. 5. List all products and the supplier for every product that have units on order. Include columns that show the ProductName, supplier's CompanyName and number of units on order. Sort the list first by supplier name and then by product name. (Hint. This will require two tables.) 6. List all products that have never been ordered. Show the ProductID and the ProductName in your results. Use a subquery in the WHERE clause