Skip to content

Instantly share code, notes, and snippets.

View IdaSofieKarlsson's full-sized avatar

Ida-Sofie Karlsson IdaSofieKarlsson

View GitHub Profile
@IdaSofieKarlsson
IdaSofieKarlsson / gist:3d282944d012cb260163ed7a5c827581
Last active October 5, 2025 22:37
PostgreSQL Advanced Queries & Relationships lesson
//Task 1: List All Players and Their Scores
SELECT
p.name AS player_name,
g.title AS game_title,
s.scores
FROM scores s
INNER JOIN players p ON s.player_id = p.player_id
INNER JOIN games g ON s.game_id = g.game_id;
//Task 2: Find High Scorers