CREATE VIEW locations_distinctpri AS
SELECT DISTINCT l_priloc from locations;