Mahindra Finance interview question

Sql query regarding customer table and order table