text: SET SEARCH_PATH TO parlgov;
  drop table if exists q5 cascade;
  
  -- You must not change this table definition.
  
  CREATE TABLE q5(
  electionId INT, 
  countryName VARCHAR(50),
  winningParty VARCHAR(100),
  closeRunnerUp VARCHAR(100)
  );
  
  -- You may find it convenient to do this for each of the views
  -- that define your intermediate steps.  (But give them better names!)
  DROP VIEW IF EXISTS intermediate_step CASCADE;
  
  -- Define views for your intermediate steps here.
  
  
  -- the answer to the query 
  insert into q5 
  