What are the ids of products from the supplier with id 2, which are more expensive than the average price across all products?
select t1.product_id from product_suppliers as t1 join products as t2 on t1.product_id = t2.product_id where t1.supplier_id = 2 and t2.product_price > (select avg(product_price) from products)