Solution
The correct answer is 4
Key PointsA "Left Outer Join" is another type of JOIN operation in SQL, which is used to combine rows from two or more tables based on a related column between them.
Unlike the Right Outer Join, the Left Outer Join returns all the records from the left table, and the matched records from the right table. If there is no match found in the right table, the result is NULL on the right-side part.
| S |
Si |
C |
P |
D |
| J |
1 |
M |
S1 |
CA |
| B |
2 |
N |
P1 |
AB |
| R |
3 |
H |
D1 |
DC |
| T |
4 |
G |
Null |
Null |
Here the above table is left outer join they have contain four row so correct answer is 4.