Zoplar Data Analyst interview questions

Table 1: 1 2 3 3 5 6 7 Table 2: 0 2 3 4 5 How would you use different types of joins (inner join, left join, right join, and full outer join) to combine these tables? Explain the results you would expect from each join type, highlighting which rows from Table 1 and Table 2 would appear in the output for each case. Additionally, discuss any scenarios where null values might be included and the reasons behind them