20181229171817_demon_view.up.sql

-- Your SQL goes here

CREATE OR REPLACE VIEW demon_verifier_publisher_join AS
SELECT p1.name AS vname, p1.id AS vid, p1.banned AS vbanned, p2.name AS pname, p2.id AS pid, p2.banned AS pbanned
FROM demons
INNER JOIN players AS p1
ON demons.verifier = p1.id
INNER JOIN players AS p2
ON demons.publisher = p2.id