BIE 6 Role (But selected in First round for BIE 5)

Part 1: Some basic sql questions
Union vs Union all
Different joins
where vs having
and some more common sql questions

Par2:
Leetcode (no execute option)

1. employee(employee_id,manager_id,join_date)
   find all the employees who joined before their manager

2. salary(department_id,employee_id,salary)
   List all employees with salary greater than the everage department salary and also greather than $50K

3. Monthly Revenue : company_name,month,revenue
   Write a query to pull the monthly revenue as columns instead of rows.

4. ID table with duplicate rows: id1,id2
   Select only the duplicate rows.

Part 3:
Bunch (A lot of) of behavioural questions and followup questions.

Cleared in First round.
Recruiter called me and said, i am not eligible for BI 6 but for BI 5. I said okay. 2nd round of interview is on the way.

First time, gonna attend onsite interview, kindly give me some guidance.