Chapter 4 Exercise 36

36. List the retail stores in Delaware. (2)

SELECT RetailStore.StoreID, RetailStore.StoreName, City.State
FROM City RIGHT JOIN RetailStore ON City.CityID = RetailStore.CityID
WHERE (((City.State)="DE"));