Yes
select product_id from product_suppliers where supplier_id = 2
What is the average price of all products?
select avg ( product_price ) from products
Only the names of those products supplied by supplier id 2.
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 )
How much does product ID 8 cost?
select product_price from products where product_id = 8
And product ID 15?
select product_price from products where product_id = 15