update queries for new schema and sql joins

[RasonJ]

now that we can do sql joins, update queries and kata

[jzonthemtn]

Closing here. If still needed, the issue can be re-created in the new repository at https://github.com/opensearch-project/user-behavior-insights.