Join tables on organisation

[Tomeriko96]

As far as I can tell from the data scheme

There are three joins possible to the organisation table:

• subject, by id = organisationId
• teacher, by id = organisationId
• genericTopic, by id = organisationId

Write a new script which attempts to do so.

Note the mutations on the resulting dataframe.

Also there appears to be a connection between ParentOrganisationId to id within the organsiation table. I am unsure how that pans out.
Look into the inter-table joins first and if time allows explore what this intra-table join amounts to.