Problem:
Question 1: Write the advantages of Knowledge-Based Path-Finding method. Explain thoroughly.
Question 2: Write a SELECT statement that returns one row for each vendor in the Invoices table that contains these columns:
a) The vendor_id column from Vendor table
b) The sum of the invoice_total columns in the Invoices table for that vendor.
Please show your work step by step.