Netcracker Technology interview question

Sql queries, joins, Java concepts