First page Back Continue Last page Image
What is Pseudocode
SELECT vendor_state, vendor_name, sum_of_invoices
FROM (subquery returning vendor_state, vendor_name,
sum_of_invoices)
JOIN (subquery returning vendor_state,
largest_sum_of_invoices)
ON vendor_state AND sum_of_invoices
ORDER BY vendor_state
Write what you know how to do
Express the idea of what you have yet to figure out