SQL : Top 3 Products by sale, % using Case, Basic Having clause and one Set operator (Intersect) type question

Python : Average word length, ip-address parsing, dictionary, list of lists, flatten list of lists. ( Similar to previous interview experiences)

Question

SQL : Top 3 Products by sale, % using Case, Basic Having clause and one Set operator (Intersect) type question

Python : Average word length, ip-address parsing, dictionary, list of lists, flatten list of lists. ( Similar to previous interview experiences)

Sigiloso · Accepted Answer

Give a list if nested lists like [[A],[B,[C]],[D,E,[F,G]]]
Convert this into a flattened
 list like [A,BC,D,E,F,G]

Sigiloso · Answer

Thanks, good luck on your onsite

Sigiloso · Answer

Hello, could you please elaborate on the flatten list of lists and list of lists questions? I haven’t found this data on other posts

Sigiloso · Answer

can you elaborate on the percent using case and set operator sql questions

Sigiloso · Answer

[A,B,C,D,E,F,G] * about the typos

Meta

Pergunta de entrevista da empresa Meta

Respostas da entrevista

Empresas seguidas

Buscas de vagas