Birlasoft interview question

Write a DBMS query for joining.