Pergunta de entrevista da empresa Church's Texas Chicken

How would you write a SQL query to answer this problem