By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | user_name | score | reputation |
---|---|---|---|
1 | Jack | 0 | 18 |
4 | James | 1 | 5 |
2 | Peter | 0 | 0 |
3 | Ali | 0 | 0 |
id | user_name | tag | tag_reputation |
---|---|---|---|
1 | Jack | css | 15 |
1 | Jack | mysql | 5 |
1 | Jack | php | 5 |
1 | Jack | html | -2 |
4 | James | html | 5 |
user_id | user_name | score | reputation | top_two_tags |
---|---|---|---|---|
1 | Jack | 0 | 18 | css,mysql |
4 | James | 1 | 5 | html |
2 | Peter | 0 | 0 | null |
3 | Ali | 0 | 0 | null |