Predict: count rows or known values?

Predict one summary per team. Count every member separately from members whose credits are known.

what to return

Columns: teammembersknown_credits in this order
Rows: 2 rows · any order
Watch for: Use the sample data shown here. NULL is not zero or empty text. Keep duplicate result rows.
Skill: Reason about the exact result of a fixed SQL query. Refresher: Group into summaries →

expected result

Your query should return exactly these columns and values. Run it and compare.

expected result2 rows · any order

team	members	known_credits
Blue	2	1
Red	2	2

all 2 rows

data you can query

Sample rows from each table. Each column shows its type underneath; → marks a link to another table.

studio_members4 columns · 4 rows

idinteger · key	nametext	teamtext	creditsinteger
1	Luz	Red	80
2	Kit	Red	80
3	Remy	Blue	50
4	Sol	Blue	NULL

all 4 rows

studio_bookings4 columns · 4 rows

idinteger · key	member_idinteger → studio_members	feeinteger	booked_attext
11	1	20	2026-04-01
12	1	30	2026-04-30
13	2	NULL	2026-05-01
14	NULL	20	2026-04-15

all 4 rows

This question asks you to predict an output. The prototype covers write and debug questions; open it in the current app.

Hints and the answer are always available. Using them counts the question as solved with help.