Sakha Global Interview Question

sql queries regarding joins?