Question

Consider the table STORE given in Q33. Choose the correct query to display Stores names, Location and Date of Opening of stores that were opened before 2015. a. Select storename, location, OpeningYear from store where OpeningYear <”2015”; b. Select storename, location, OpeningYear from store where OpeningYear >”2015”; c. Select storename, location, OpeningYear from store where OpeningYear =2015; d. Select storename, location, OpeningYear from store where OpeningYear !=2015;

Answer 1

Answer: Select storename, location, Opening Year from store where Opening Year =2015;