By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | author | code_art |
---|---|---|
1 | Adams | 1 |
2 | Matt | 1 |
3 | Grace | 1 |
4 | Harry | 2 |
5 | Scott | 2 |
6 | Sarah | 2 |
7 | Tony | 3 |
8 | Lucy | 3 |
9 | Zoe | 3 |
10 | Megan | 3 |
11 | Emily | 4 |
12 | Peter | 4 |
13 | John | 5 |
14 | Kate | 5 |
15 | James | 6 |
16 | Cole | 6 |
17 | Dennis | 7 |
18 | Smith | 7 |
19 | Zack | 7 |
20 | Jill | 7 |
id | author | code_art | rnum |
---|---|---|---|
1 | Adams | 1 | 1 |
2 | Matt | 1 | 2 |
3 | Grace | 1 | 3 |
4 | Harry | 2 | 1 |
5 | Scott | 2 | 2 |
6 | Sarah | 2 | 3 |
7 | Tony | 3 | 1 |
8 | Lucy | 3 | 2 |
9 | Zoe | 3 | 3 |
10 | Megan | 3 | 4 |
11 | Emily | 4 | 1 |
12 | Peter | 4 | 2 |
13 | John | 5 | 1 |
14 | Kate | 5 | 2 |
15 | James | 6 | 1 |
16 | Cole | 6 | 2 |
17 | Dennis | 7 | 1 |
18 | Smith | 7 | 2 |
19 | Zack | 7 | 3 |
20 | Jill | 7 | 4 |
id | author | title | rating | id | author | code_art | rnum |
---|---|---|---|---|---|---|---|
1 | Adams | M | 33 | 1 | Adams | 1 | 1 |
1 | Adams | M | 33 | 2 | Matt | 1 | 2 |
1 | Adams | M | 33 | 3 | Grace | 1 | 3 |
2 | Matt | M | 31 | 4 | Harry | 2 | 1 |
2 | Matt | M | 31 | 5 | Scott | 2 | 2 |
2 | Matt | M | 31 | 6 | Sarah | 2 | 3 |
3 | Grace | F | 25 | 7 | Tony | 3 | 1 |
3 | Grace | F | 25 | 8 | Lucy | 3 | 2 |
3 | Grace | F | 25 | 9 | Zoe | 3 | 3 |
4 | Harry | M | 20 | 11 | Emily | 4 | 1 |
4 | Harry | M | 20 | 12 | Peter | 4 | 2 |
5 | Scott | M | 30 | 13 | John | 5 | 1 |
5 | Scott | M | 30 | 14 | Kate | 5 | 2 |
6 | Sarah | F | 30 | 15 | James | 6 | 1 |
6 | Sarah | F | 30 | 16 | Cole | 6 | 2 |
7 | Tony | M | 30 | 17 | Dennis | 7 | 1 |
7 | Tony | M | 30 | 18 | Smith | 7 | 2 |
7 | Tony | M | 30 | 19 | Zack | 7 | 3 |
8 | Lucy | F | 27 | null | null | null | null |
9 | Zoe | F | 30 | null | null | null | null |
10 | Megan | F | 26 | null | null | null | null |