Meta Interview Question

given some sample web UI log data, write a SQL query to answer various questions