UKG interview question

Questions related to SQL like self joins, window function and stored procedure