CTS interview question

Basic of java , oops , sql(joins and subquires).