Consider the following relations:
Which of the following query gives suppliers names who have submitted at least one ‘Harvest’ brand item? (sno in item is the foreign key referencing sno in supplier).
I. Select sname FROM Supplier S, Item t where t.brand = ‘Harvest’
II. Select sname FROM Supplier S where sno IN (Select sno FROM Item where brand = ‘Harvest’)
What will be the correct answer for above question?