write SQL queries to create procedures for a database called Saleco. The database contains the following tables: customer, invoice, line, product, and vendor. A procedure called get_customer_invoices that takes a customer ID as input and returns a list of all invoices for that customer, along with the total amount due for each invoice. A procedure called get_vendor_products that takes a vendor ID as input and returns a list of all products sold by that vendor, along with the number of units sold and the total revenue generated for each product. A procedure called get_invoice_details that takes an invoice ID as input and returns a list of all products purchased on that invoice, along with the quantity purchased, the unit price, and the total price for each product.

write SQL queries to create procedures for a database called Saleco. The database contains the following tables: customer, invoice, line, product, and vendor.

A procedure called get_customer_invoices that takes a customer ID as input and returns a list of all invoices for that customer, along with the total amount due for each invoice.

A procedure called get_vendor_products that takes a vendor ID as input and returns a list of all products sold by that vendor, along with the number of units sold and the total revenue generated for each product.

A procedure called get_invoice_details that takes an invoice ID as input and returns a list of all products purchased on that invoice, along with the quantity purchased, the unit price, and the total price for each product.