Survey:

CREATE TABLE Person (id text, personal text, family text);

CREATE TABLE Site (name text, lat real, long real);

CREATE TABLE Survey (taken integer, person text, quant text, reading real);

CREATE TABLE Visited (id integer, site text, dated text);

------------------

So what is this assignment all about? You will be performing 4 queries:

1. where you are joining three tables (you'll have at least one join in all your queries, but for this one you should be joining 3 table together). (This can use concepts from Selecting Data, Combining Data, Sorting and Removing Duplicates, or Missing Data)
2. where you are aggregating data using group by with multiple groups. (This can use concepts from Selecting Data, Combining Data, Aggregation, Calculating New Values, Sorting or Removing Duplicates, or Filtering)