CREATE OR REPLACE VIEW top5_invoice_totals AS
SELECT vendor_id, invoice_total
FROM invoices
ORDER BY invoice_total DESC
LIMIT 5
In this example we have added a LIMIT command to the result of the VIEW
This allows us to use views to focus on the most important data without having to change queries intended for more comprehensive output
Right now who are the 5 people I owe the most money to and how much do I owe them