Real-Time Patient Risk Stratification Algorithm

Create a complex SQL query that calculates dynamic patient risk scores using multiple medical data sources. The algorithm must combine: chronic condition history, medication interactions, genetic markers, recent diagnostic tests, and demographic factors. Implement a weighted scoring mechanism that produces a real-time risk classification (Low/Medium/High) with confidence intervals. The solution should handle missing data gracefully and update scores incrementally.