ZS Associates interview question

SQL guesstimate puzzle project behavioural question