Verifone interview question

2 coding questions on streams, MYSQL join query, subquery, Java basic to intermediate questions