The avatar for @sgavin93
Sakura Gavin
Public
Edited
Oct 31, 2023
3
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
db
SELECT DISTINCT playerID
FROM college
WHERE EXISTS (
SELECT *
FROM people
WHERE weight > 250 AND playerID = college.playerID
)
Insert cell
db
SELECT DISTINCT playerID
FROM college
WHERE 250 < (
SELECT weight
FROM people
WHERE playerID = college.playerID
)
Insert cell
db
SELECT playerID
FROM people
WHERE weight > 250 AND EXISTS (
SELECT playerID
FROM college
WHERE playerID = people.playerID
)
Insert cell
db
SELECT DISTINCT playerID
FROM college
WHERE 1 = (
SELECT count(*)
FROM hall
WHERE playerID = college.playerID
)
Insert cell
db
SELECT DISTINCT playerID
FROM college
WHERE 1 = (
SELECT count(*)
FROM hall
WHERE playerID = college.playerID
) AND 'Y' = (
SELECT inducted
FROM hall
WHERE playerID = college.playerID
)
Insert cell
db
SELECT DISTINCT playerID
FROM hall
GROUP BY playerID
HAVING count(*) = 1 AND EXISTS (
SELECT *
FROM college
WHERE playerID = hall.playerID
)
Insert cell
db
SELECT DISTINCT playerID
FROM hall
GROUP BY playerID
HAVING count(*) = 1 AND EXISTS (
SELECT *
FROM college
WHERE playerID = hall.playerID
) AND max(inducted) = 'Y'
Insert cell

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.
Learn more