Baltimore is an area facing a high number of food deserts. There is a disproportionate amount of convenience stores to grocery stores, which results in difficulty accessing healthy foods. This link is intended to provide resources to families in food deserts about where to obtain healthy food, use food benefits and find store locations with high health indices in their areas (using SQL). The site can be accessed here.
DROP PROCEDURE IF EXISTS SuperMarketsNearMe // CREATE PROCEDURE SuperMarketsNearMe(IN ss VARCHAR(5)) BEGIN IF EXISTS(SELECT zipcode FROM FoodStore WHERE zipCode=ss) THEN SELECT * FROM FoodStore WHERE zipcode = ss ORDER BY type ASC; ELSE SELECT * FROM FoodStore WHERE zipCode IN (SELECT zipCode FROM FoodStore ORDER BY type ASC) ORDER BY ABS(zipCode - ss) ASC; END IF; END;