Pergunta de entrevista da empresa Canva

How could you re-write this SQL statement to make it more efficient? How would you scale this system to handle a large number of users and TBs of data?