Temenos interview question

Questions on JOIN and BETWEEN in SQL ?