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)

Anonymous · 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]

Anonymous · Answer

Thanks, good luck on your onsite

Anonymous · 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

Anonymous · Answer

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

Anonymous · Answer

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

Meta

Meta interview question

Interview Answers

Followed companies

Job searches

Bowls

Want the inside scoop on your own company?