Nagwa interview question

SQL indexes and choosing index columns based on queries