mickeypash · May 2, 2015 14:40
diff --git a/sql_queries.sql b/sql_queries.sql
 -- 17. Get the names of people, who live at the same address
 SELECT fname, sname, address 
 	FROM Member
 	WHERE address = (SELECT address 
 						FROM Member 
 						GROUP BY address HAVING COUNT(address) > 1);
	-- 17. Get the names of people, who live at the same address
	SELECT fname, sname, address
	FROM Member
	WHERE address = (SELECT address
	FROM Member
	GROUP BY address HAVING COUNT(address) > 1);