تحليل بيانات خاصه بالمستشفى

تحليل بيانات باستخدام لغه SQL للاجابه عن الاساله الاتيه:

1. Total Patients

2. View Patient with Medical History

3. View Scheduled Appointments

4. View Doctor's Appointments

5. View Unpaid Bills

6. Get Total Bills for each Patients

7. View All Patients With each Doctor

8. View Billing Report for a month of octobar

9. Find Patients Who Have Had Appointments With More Than One Doctor

10.Get a List of Doctors and Their Total Appointments in a month of octobar

11.Retrieve Total Income Generated From Appointments for Each Doctor

12. Find Patients Who Have Not Paid Their Bills (Pending Bills)

13.Get a List of Patients Who Have Missed (Cancelled) Appointments

14.Calculate the Average Bill Amount for All Patients

15.Get Total Appointments Per Day

16. Find Patients Who Have Not Visited in the Last 6 Months

17.Calculate Total Revenue by Month

18. Find the Most Frequent Patients (Top 3 Patients Based on Number of

Appointments