-- VIEW with DISTINCT
CREATE VIEW test_view_distinct AS
SELECT DISTINCT id_subject, id_subjecttype FROM idm.reg_subject;
