Data Insights Manager Interview Questions and Answers

Ranking where 2 people have the same marks in a dataset.

• Identify the individuals with the same marks.

• Assign them the same rank.

• Adjust the subsequent ranks accordingly.

Left join includes all records from the left table and matching records from the right table, while inner join only includes matching records from both tables.

• Left join retains all records from the left table, even if there are no matches in the right table.

• Inner join only includes records that have matching values in both tables.

• Left join is useful for including all data from one table, while inner join is used to only include matching data from both tables.