Fujitsu interview question

SQL queries procedures function