Atlassian interview question

Write an example SQL script!