استعلام الإحصائيات:

SELECT 
                (SELECT COUNT(DISTINCT s.SchoolID)
                 FROM school s
                 JOIN edara e ON s.EdaraID = e.EdaraID
                 JOIN government g ON e.GovID = g.GovID
                 
                ) AS total_schools,
                (SELECT COUNT(DISTINCT sd.School_id)
                 FROM schoolsdata sd
                 JOIN school s ON sd.School_id = s.SchoolID
                 JOIN edara e ON s.EdaraID = e.EdaraID
                 JOIN government g ON e.GovID = g.GovID
                 
                ) AS visited_schools,
                (SELECT COUNT(*)
                 FROM schoolsdata sd
                 JOIN school s ON sd.School_id = s.SchoolID
                 JOIN edara e ON s.EdaraID = e.EdaraID
                 JOIN government g ON e.GovID = g.GovID
                 
                ) AS total_visits,
                (SELECT COUNT(DISTINCT sd.week)
                 FROM schoolsdata sd
                 JOIN school s ON sd.School_id = s.SchoolID
                 JOIN edara e ON s.EdaraID = e.EdaraID
                 JOIN government g ON e.GovID = g.GovID
                 
                ) AS total_weeks

المعاملات (عدد 0):

Array
(
)

الأنواع: