Frage im Vorstellungsgespräch bei Forter

query over some tables a difficult SQL that required joins, group-by clauses, and window functions very basic python coding. how would you design a service for shorting URLs