Pregunta de entrevista de Verifone

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