online assessment with 3 presql questions onsite: 3 round BQ half hour (my questions is why Wayfair, tell me about yourself, compromise with co-workers, project) case study 1 hours design ERD read code understanding the business 1 hour

First round was a coding test and business question test. Coding was on SQL and difficulty was medium. The questions were on joins, case and group by. Business round was a little difficult for me