Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
1280. Students and Examinations
--PostgreSQL 9.6 --'\\' is a delimiter drop table if exists Subjects; drop table if exists Examinations; Create table Students_1 ("student_id" int, "student_name" varchar(20)); Create table Subjects ("subject_name" varchar(20)); Create table Examinations ("student_id" int, "subject_name" varchar(20)); insert into Students_1 (student_id, student_name) values (1, 'Alice'), (2, 'Bob'), (13, 'John'), (6, 'Alex'); insert into Subjects (subject_name) values ('Math'), ('Physics'), ('Programming'); insert into Examinations (student_id, subject_name) values (1, 'Math'), (1, 'Physics'), (1, 'Programming'), (2, 'Programming'), (1, 'Physics'), (1, 'Math'), (13, 'Math'), (13, 'Programming'), (13, 'Physics'), (2, 'Math'), (1, 'Math');
run
|
edit
|
history
|
help
0
postgresql select test
2
pgsql trigger 01 - Ovocie
Assignment 1(SET A)
E-commerce Website SQL Analysis
lol
PostgresInsertIfNotExists
Islands demonstration
Select all countries that can be found by recursively adding all neighbouring countries (PostgreSQL)
Webiste SQL Analysis