▣CPSC 304 LabInteractive exam preparation
0 / 31 solved
CATEGORY · LECTURE MODE

Chapter 01 · SQL foundations: SELECT & projection

Build the tools you need before facing the Exam Mode set.
0%
Live Tables
No relationship is needed for this task; work directly from the displayed relation.
Table: ParticipantRead-only
pidnamecountry
P01HanzKorea
P02MinaKorea
P03AlexCanada
P04SoraJapan
P05LeoItaly
P06NoorEgypt
P07AmaraKenya
P08MateoSpain
P09PriyaIndia
P10EthanCanada
Task 1 · Read the whole relation2 points

Show every participant with all three displayed details. Keep the rows in the same top-to-bottom sequence as the Participant table.

Query Results live
⊞Start typing a SELECT query.
SQL Results update automatically after you pause.