quality measure 0034 timeout fix

[bradmontierth]

Describe your changes

Please include a summary of any changes. replace OR in inner join with 2 separate inner join statements in CTEs replace BETWEEN with explicit >= <=

How has this been tested?

Please describe the tests you ran to verify your changes. Provide instructions or code to reproduce output. fixed timeout issue at client, runs in 1 minute.

Reviewer focus

Please summarize the specific items you’d like the reviewer(s) to look into.

Checklist before requesting a review

• [ ] I have added at least one Github label to this PR (bug, enhancement, breaking change,...)
• [ ] My code follows style guidelines
• [ ] (New models) YAML files are categorized by sub folder and models listed in alphabetical order
• [ ] (New models) I have added a config to each new model to enable it for claims and/or clinical data
• [ ] (New models) I have added the variable tuva_last_run to the final output
• [ ] (Optional) I have recorded a Loom to explain this PR

Package release checklist

• [ ] I have updated dbt docs
• [ ] I have updated the version number in the dbt_project.yml

(Optional) Gif of how this PR makes you feel

Loom link