Visa Inc. interview question

SQL questions 1.) inner join vs outer join 2.) Creating a new column based on condition on first column. 3.) Finding median value without using median function. 4.) Finding quartiles