Question d’entretien chez 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?