Wipro interview question

explain the state management, joins in sql