PHPize Online / SQLize Online  /  SQLtest Online

# 問1 CREATE TABLE students ( student_name NCHAR(20) NOT NULL, university_name NCHAR(50) NOT NULL, address NCHAR(100), PRIMARY KEY (student_name) ); # 問2 INSERT INTO students VALUES ('Taro Yamada', 'Reiwa University', 'Minato, Tokyo'); INSERT INTO students VALUES ('Hanako Suzuki', 'Reiwa University', 'Musashino, Tokyo'); INSERT INTO students VALUES ('Ichiro Sato', 'The University of Tokyo', 'Bunkyo, Tokyo'); # 問3 SELECT * FROM students; # 問4 CREATE TABLE jobs ( student_name NCHAR(20) NOT NULL, company_name NCHAR(50) NOT NULL, salary INT, PRIMARY KEY (student_name, company_name) ); # 問5 INSERT INTO jobs VALUES ('Taro Yamada', 'A Corporation', 40); INSERT INTO jobs VALUES ('Hanako Suzuki', 'B News Agency', 60); INSERT INTO jobs VALUES ('Ichiro Sato', 'A Corporation', 50); # 問6 SELECT * FROM jobs; # 問7 CREATE TABLE companies ( company_name NCHAR(20) NOT NULL, address NCHAR(100) NOT NULL, PRIMARY KEY (company_name) ); # 問8 INSERT INTO companies VALUES ('A Corporation', 'Shinjuku'); INSERT INTO companies VALUES ('B News Agency', 'Shibuya'); # 問9 SELECT * FROM companies;