Four tables in database :
    | DoctorDetails(DoctorID,FirstName,LastName,Gender,DateOfBirth,Specialization,ContactNumber,EmailAddress,Address,MedicalLicenseNumber,HospitalID),
    | NurseDetails(NurseID,FirstName,LastName,Gender,DateOfBirth,ContactNumber,EmailAddress,Address,HospitalID),
    | HospitalDetails(HospitalID,HospitalName,Address,City,State,ZipCode,PhoneNumber,EmailAddress,NumberOfBeds,Description,AdministratorName),
    | HospitalData(PatientID,PatientName,PatientArrival,HospitalID,Emergency[True/False],DoctorID,DoctorConsulting,Nurse,ConditionNow,Discharged[True/False])
    Write an SQL query for this question based on given Database : "{How many patients have cardiological disease?}" In your response, capitalize a few words to stress main points. Please limit the number of words with all capital letters to less than 3.
user