Pregunta de entrevista de RealSelf

Using python (or other scripting language), create a simple extraction tool which extracts from MySQL into JSON files. With the following table schema, which columns could be used for a join.