SQL: Cheapest Supplier per Item
Return the lowest price supplier for each SKU.
Before you answer
State the key, the expected grain and one edge case you would test. The goal is not only to get a result, but to know why it is correct.
Hint
Rank quotes by price partitioned by SKU.
Completion is stored only in this browser.