CREATE TABLE lakes_qc AS SELECT * FROM lakes WHERE province='QUEBEC';