CREATE TABLE florist AS SELECT * FROM product WHERE category = ’flower’;
INSERT INTO new_table SELECT * FROM old_table