-- Using the ap database
-- 1. Return the invoices for vendor names that start with P
-- 2. Count the number of invoices for each vendor, return the vendor_id, vendor_name and the count

-- 3. Calculate the total payment by vendor, return the vendor name and the total
-- 4. Provide a JOIN across the invoice_line_items and the invoices table, verify the results of invoice_total
-- 5. Calculate the total payment by vendor, return the vendor id , vendor name  and the total payment for vendor for vendors who paid more than $100
