Database: department_store
Question: What are the ids of products from the supplier with id 2, which are more expensive than the average price across all products?
SQL:
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)