The avatar for @observablehq
Observable
The end-to-end solution for building and hosting better data apps, dashboards, and reports.
Published
SQL Mystery Game
Edited
Jun 16, 2022
2 forks
6 stars
1
Insert cell
Insert cell
Insert cell
Insert cell
db = FileAttachment("sql-murder-mystery.db").sqlite()
Insert cell
Insert cell
db
select * from crime_scene_report where city = 'SQL City' AND date = 20180115
Insert cell
Insert cell
db
select * from person where address_street_name = 'Northwestern Dr' order by address_number DESC;
Insert cell
Insert cell
db
select * from person where name LIKE '%Annabel%' AND address_street_name = 'Franklin Ave' order by address_number DESC;
Insert cell
Insert cell
db
select * from interview WHERE person_id IN (16371,14887)
Insert cell
Insert cell
db
select * from get_fit_now_member where membership_status = 'gold' AND id LIKE '48Z%'
Insert cell
Insert cell
db
select * from person WHERE id IN (28819, 67318)
Insert cell
Insert cell
db
select * from get_fit_now_check_in WHERE membership_id in ('48Z7A', '48Z55')
Insert cell
Insert cell
db
select person.name, drivers_license.*
from drivers_license
join person on drivers_license.id = person.license_id
WHERE plate_number like '%H42W%'
Insert cell
Insert cell
Insert cell
db
INSERT INTO solution VALUES (1, 'Jeremy Bowers');
SELECT value FROM solution;
Insert cell
Insert cell
Insert cell
db
select * from interview WHERE person_id IN (67318)
Insert cell
Insert cell
db
select *
from drivers_license
join person on drivers_license.id = person.license_id
where car_make = 'Tesla' and car_model = 'Model S' and gender = 'female' and hair_color = 'red'
Insert cell
Insert cell
db
select * from facebook_event_checkin where person_id in (78881,90700,99716)
Insert cell
Insert cell
db
select *
from facebook_event_checkin
join person on facebook_event_checkin.person_id = person.id
where person_id in (78881,90700,99716)
Insert cell
Insert cell
db
INSERT INTO solution VALUES (1, 'Miranda Priestly');
SELECT value FROM solution;
Insert cell
Insert cell
Insert cell
Insert cell
diagram(db)
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