CoForge | OA | 10 Nov, 2025 | MySQL: Patients Diagnosis Report

Question: MySQL: Patients Diagnosis Report Environment Specifications & Instructions Type of Database: MySQL Database Name to be used: HospitalDb Problem Statement Write a MySQL query to create a report that combines diagnosis and treatment data for selected patients and diagnosis dates. The report should include the following columns: patient_name: The name of the patient. diagnosis_date: The date of diagnosis. record_type: "Diagnosis" for diagnosis data and "Treatment" for treatment data. record_description: The description in the diagnosis or treatment column. The report ...