WHERE playerID = people.playerID) = 0 THEN 'NEVER MANAGED'
ELSE (SELECT count(*)
FROM managers
WHERE playerID = people.playerID)
END
FROM people
db
SELECT DISTINCT playerID,nameFirst,nameLast,
CASE (SELECT max(inducted)
from hall
WHERE playerID = people.playerID)
WHEN 'Y' THEN 'inducted'
WHEN 'N' THEN 'considered'
ELSE 'not considered'
END
FROM people
db
SELECT *
FROM hall
WHERE playerID = 'abbotji01'
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.