By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
CREATE TABLE
INSERT 0 4
| gameid | seasonid |
|---|---|
| 1 | 15 |
SELECT 1
| gameid | period | awayscore | homescore |
|---|---|---|---|
| 1 | 1 | 10 | 10 |
| 1 | 2 | 10 | 10 |
| 1 | 3 | 10 | 10 |
| 1 | 4 | 10 | 10 |
SELECT 4
CREATE TABLE
CREATE TABLE
INSERT 0 4
| gameid | seasonid |
|---|---|
| 1 | 15 |
SELECT 1
| gameid | period | awayscore | homescore |
|---|---|---|---|
| 1 | 1 | 10 | 10 |
| 1 | 2 | 10 | 10 |
| 1 | 3 | 10 | 10 |
| 1 | 4 | 10 | 10 |
SELECT 4