What queries would you use to find these?

1. List of patients with expired insurance cards that need to be contacted and updated.
2. List of patients to be contacted if they need a routine colonoscopy (Males over 50 years old) or breast exam (Women over 40 years old).
3. What is the number of patients each doctor has seen per practice?
4. How many patients have at least one member of their family in the network? (Insurance #'s should match)
5. How many patients were seen in the month of November?
6. What is the average age of patients seen by a Gastroenterologist?
7. How many Patients use Tri Care?
8.  

Transcribed Image Text:

Patient_id Patient_first_name 1572453982 Danya 9533396040 Moise 7069817185 Giraldo 1715954629 Agna 1262131596 Gustavo 7261521647 Karolina 7374345127 Corabel 3862310094 Delphinia Patient_last_name Patient Age Doctor Specialty gender Procedure Annual checkup Annual checkup Annual checkup Endocrine surgery Annual checkup Breast exam Routine procedure Brookes Behling Dabnor Dabnor Cloney Davies Cammis Robben 5 35 7 8 30 31 刀 刀 75 85 47 48 80 72 79 Cardiologist Dermatologist Cardiologist Surgeon Dermatologist Family Medicine Family Medicine Family Medicine Female Male Male Female Male Female Female Female Annual checkup Doctor_Name Richard Lucz John Bouser Susan Owtram Wallace Filby John Bouser Dana Vinias Dana Vinias Keith Jones Insurance_Type Tri Care Bright Health Care Cigna Cigna Medicare Bright Health Care Bright Health Care Cigna Insurance Numb 6874345737 2707392146 926829394 926829394 3214780557 9587157680 9955516992 9903468482 Patient_id Patient_first_name 1572453982 Danya 9533396040 Moise 7069817185 Giraldo 1715954629 Agna 1262131596 Gustavo 7261521647 Karolina 7374345127 Corabel 3862310094 Delphinia Patient_last_name Patient Age Doctor Specialty gender Procedure Annual checkup Annual checkup Annual checkup Endocrine surgery Annual checkup Breast exam Routine procedure Brookes Behling Dabnor Dabnor Cloney Davies Cammis Robben 5 35 7 8 30 31 刀 刀 75 85 47 48 80 72 79 Cardiologist Dermatologist Cardiologist Surgeon Dermatologist Family Medicine Family Medicine Family Medicine Female Male Male Female Male Female Female Female Annual checkup Doctor_Name Richard Lucz John Bouser Susan Owtram Wallace Filby John Bouser Dana Vinias Dana Vinias Keith Jones Insurance_Type Tri Care Bright Health Care Cigna Cigna Medicare Bright Health Care Bright Health Care Cigna Insurance Numb 6874345737 2707392146 926829394 926829394 3214780557 9587157680 9955516992 9903468482

Answer rating: 100% (QA)

List of patients with expired insurance cards that need to be contact... View the full answer