SQL Basics -Subquery from THENEWBOSTON

Instruction: Give me the name of an item that costs the least.

SELECT name, MIN(cost)

FROM items

WHERE name LIKE "%boxes of chocolates"

AND seller_id

IN(

SELECT seller_id FROM items WHERE name LIKE "%boxes of chocolates"

)

name	MIN(cost)
3 boxes of chocolates	30.4899997711182

Source: 

https://youtu.be/rDqtBKEY9Ok

https://youtu.be/6BfofgkrI3Y