Write and execute the following queries for the $"$ap$"$ database.

Q$1(10$ points$)$: Write a SELECT statement that returns these four columns:

vendor$\_$name The vendor$\_$name column from the Vendors table

invoice$\_$number The invoice$\_$number column from the Invoices table

invoice$\_$date The invoice$\_$date column from the Invoices table

balance$\_$due The invoice$\_$total column minus the payment$\_$total

and credit$\_$total columns from the Invoices table