Revolut Interview Question

Write an SQL query with group by aggregate functions. Write an SQL query with window functions. Also know your joins, and when to use them (left join vs right join vs inner join)