Verifone Interview Question

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