3. List the customer names and phone numbers of customers from British Colombia (state = BC) who have never participated in a sale. Order the results by the customer last name then by customer first name.

4. Show the first name, lastname,and compensation for each employee. Your result should have four columns: firstname, lastname, salary, and wage. For employees who have a salary, show it in the salary column and leave the wage column blank. For wage earners, show their wage in the wage column and leave the salary column blank. Sort the results by last name, then by first name.

This is with SQL MyEducator, could you please help me with the queries?

Manufacturer ManufacturerlD ManufacturerName Address Address2 City State PostalCode Phone Fax Contact URL Customer Product ProductID ProductName ManufacturerlD Composition ListPrice Gender Category Color Description y CustomerlD FirstName LastName StreetAddress City State PostalCode Country Phone Saleltem ProductiD ItemSize SalelD Quantity SalePrice Inventoryltem Purchaseltem ProductiD 1 *d ProductlD 11emSize ItemSize OtyOnHand x PrchaselD Quantity PurchasePrice temSize 1 Sale ItemSize SalelD SaleDate CustomerID Tax Shipping Purchase PurchaselD PurchaseDate Employee EmployeelD FirstName LastName Address City State ZIP Phone ManagerlD SSN EmailAddress HireDate 1EmployeelD ExpectedDeliveryDate ManufacturerlD Shipping SalaryEmployee EmployeeID | Salary WageEmployee EmployeelD Wage MaxHours