Question

Seema wants to display Store Name and Owner Name of all stores in Mumbai. Help her select the correct query from the options given below:

a. Select Store Name, Owner Name from STORE, OWNER where store. OwnerId=Owner. OwnerId or Location=”Mumbai”; 

b. Select Store Name, Owner Name from STORE, OWNER where store. OwnerId = Owner. OwnerId and Location=”Mumbai”; 

c. Select Store Name, Owner Name from STORE, OWNER where Location=”Mumbai”; 

d. Select Store Name, Owner Name from STORE, OWNER where OwnerId = OwnerId and Location=”Mumbai”;

Answer 1

Correct option: b. Select Store Name, Owner Name from STORE, OWNER where store. OwnerId=Owner. OwnerId and Location=”Mumbai”;