Icertis interview question

SQL basics, joins, group by, having , stored procedure