VEON interview question

Write some SQL queries (with increasing difficulty).