/* SQL: Quiz 2-3 -- SELECT */
CREATE TABLE STUDENT(
	SID	CHAR(3) PRIMARY KEY,
	NAME	CHAR(10),
	CLASS	CHAR(2),
	GENDER	CHAR(1),
	SCORE	INT
);

INSERT INTO STUDENT VALUES
('001','Amy','1B','F',70),
('002','Ben','1C','M',40),
('003','Eva','1B','F',50),
('004','Dan','1A','M',80),
('005','Cat','1A','F',90),
('006','Fed','1C','M',60);

/* SQL: Quiz 04 -- UPDATE/INSERT */
CREATE TABLE STUDENT(
	SID	CHAR(3) PRIMARY KEY,
	NAME	CHAR(10),
	CLASS	CHAR(2),
	GENDER	CHAR(1),
	SCORE	INT
);

CREATE TABLE MEMBER(
	SID	CHAR(3) PRIMARY KEY,
	NAME	CHAR(10),
	CLASS	CHAR(2),
	GENDER	CHAR(1)
);

INSERT INTO STUDENT VALUES
('001','Amy','1B','F',70),
('002','Ben','1C','M',40),
('003','Eva','1B','F',50);

INSERT INTO MEMBER VALUES
('001','Dan','1A','M'),
('002','Cat','1A','F'),
('003','Fed','1C','M');

/* SQL: Quiz 05 -- JOIN */
create table Table1 (ID char(1));
create table Table2 (ID char(1));
create table Table3 (ID char(1));

insert into table1 values ('x'),('y');
insert into table2 values ('a'),('b'),('c');
insert into table3 values ('k'),('m');

create table stud (CNO int, ACT char(3));
create table club (ACT char(3), Name char(10));

insert into stud values (1,'S01'),(2,'S03'),(3,'S77');
insert into club values ('S01','Club A'),('S02','Club B'),('S03','Club C');