Pergunta de entrevista da empresa bet365

SQL assessment question involving select concat and case when statements. how to evaluate a slow database query. system design - how would sports data coming in to bet365 route through services and appear on the website.