Type 2 Nested Queries

This looks like SQL homework. If you give us your answer, I would be happy to help you (I don't like to do other people homework).

How far can you get by yourself? Do you understand the question?

The first two lines are defining SQL tables. The second part is setting up the answer with blanks. Coming up with the condition is, I suppose, the trickiest part.

i already did. I just want to compare my answer with all answers

If you post your answer, I will comment on it. I am a professional software engineer... so I can give you real feedback.

select suplierid
from product
where exist
(select productid
from orderitem
where unitprice>100$
i don't whether it is correct or not.

OK... this is a start, it isn't quite right.

When you analyze these things.... you start by asking what the inner SELECT is going to return.

You say "SELECT productid from orderitem where unitprice > 100". This is going to return all rows from the order item table with a price greater than 100. It will return too many rows... i.e. rows that don't apply.

What you have written will go through each row in product and ask "Is there any row in any product that has a price > 100". This second select will always be true, and so you will return every supplier. The assignment is to not return suppliers with no products that cost more than $100.

What you want for this inner SELECT is to only return rows that belong to a specific supplier. HINT: you want to add a constraint to the condition. Do you want to try it?