HARMAN Interview Question

joins , windows function, scenarios based question on talend as well as sql