No one has followed this question yet.
write a query to display all vendors with any cariation of a PO Box mailing address (P.O. box, PO Box, P O Box, etc) that are from the state of California. Show the VendorName, VendorAddress1, VendorCity, and VendorState.
Write a query to calculate the invoice total with a 15% tax rate applied to it. Display the InvoiceTotal, the Tax, and the Total (add the tax amount to the invoicetotal) for invoices with a balance due only.