Pergunta de entrevista da empresa Verifone

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