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