SELECT id INTO TEMPORARY documents_filtered FROM document WHERE document.pct = 't' AND document.app_date > '2019-01-01';

SELECT title.doc_id, title.text_en, inventor.name FROM title INNER JOIN documents_filtered ON title.doc_id = documents_filtered.id INNER JOIN inventor ON title.doc_id = inventor.doc_id WHERE inventor.country = 'CA' GROUP BY title.doc_id, title.text_en, inventor.name;