%load_ext sqlitemagic

%%sqlite survey.db
select * from Site join Visited;

%%sqlite survey.db
select * from Site join Visited on Site.name=Visited.site;

%%sqlite survey.db
select Site.lat, Site.long, Visited.dated
from   Site join Visited
on     Site.name=Visited.site;

%%sqlite survey.db
select Site.lat, Site.long, Visited.dated, Survey.quant, Survey.reading
from   Site join Visited join Survey
on     Site.name=Visited.site
and    Visited.ident=Survey.taken
and    Visited.dated is not null;

%%sqlite survey.db
select rowid, * from Person;