Atlassian interview question

SQL queries on joins and HAR logs