Uncommon SQL 2

Hi again!
Continuing the example from yesterday, the following query shows the the real power of that syntax:

MariaDB [tt]> select * from vending_price where (price,product_id) in
                      (select max(price),product_id
                       from vending_price group by product_id);