Pregunta de entrevista de SoundCloud

1.part : Simple SQL questions however table names are so ambiguous to write exact query quickly. 2.part : a comment question which was related to improving their current system. 3. Part: modeling a dataset