Mastercard Data Analyst interview questions

The HR reached out to me and scheduled the interview the same afternoon, the first round was SQL only questions were on joins and window functions one question on what would be the output for a left and right join , then 2 medium hard questions on window functions and one very hard question on window functions