SQL Quiz #3
use sql_quiz;
CREATE TABLE t3 (
Name varchar(255),
F1 varchar(255),
F2 varchar(255),
F3 varchar(255),
F4 varchar(255)
);
INSERT INTO t3 (Name, F1, F2, F3, F4) values ('Andy', 'Apple', 'Pear', 'Plum', 'Strawberry');
INSERT INTO t3 (Name, F1, F2, F3, F4) values ('Mike', 'Pear', 'Watermelon', 'Banana', '');
INSERT INTO t3 (Name, F1, F2, F3, F4) values ('Ryan', 'Melon', 'Banana', 'Plum', 'Strawberry');
INSERT INTO t3 (Name, F1, F2, F3, F4) values ('William', 'Melon', '', '', '');
INSERT INTO t3 (Name, F1, F2, F3, F4) values ('Emma', 'Pear', 'Plum', 'Apple', 'Strawberry');
INSERT INTO t3 (Name, F1, F2, F3, F4) values ('Jacob', 'Plum', 'Strawberry', 'Apple', 'Pear');
INSERT INTO t3 (Name, F1, F2, F3, F4) values ('Isabella', 'Dragonfruit', 'Coconut', 'Durian', 'Blackberry');
SELECT * FROM t3;
같은 과일을 좋아하는 사람을
