<?php
 
$author = 1;
$status = "Completed";
$stmt = $con->prepare("SELECT COUNT(i.id_course),
                            AVG(ra.rating) AS avg_rating
                        FROM tbl_inscribed i
                        JOIN tbl_ratings ra
                        LEFT JOIN tbl_courses c ON i.id_course = c.id_course AND ra.id_course = c.id_course
                        LEFT JOIN tbl_author a ON c.author = a.id_author
                        WHERE a.id_author=? AND i.status=?
                        ");
$stmt->bind_param("is", $author, $status);
$stmt->execute();
$stmt->bind_result($enrolled_instructor, $avg_rating);
$stmt->fetch();
$stmt->close();

PD9waHAKCiRhdXRob3IgPSAxOwokc3RhdHVzID0gIkNvbXBsZXRlZCI7CiRzdG10ID0gJGNvbi0+cHJlcGFyZSgiU0VMRUNUIENPVU5UKGkuaWRfY291cnNlKSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgIEFWRyhyYS5yYXRpbmcpIEFTIGF2Z19yYXRpbmcKICAgICAgICAgICAgICAgICAgICAgICAgRlJPTSB0YmxfaW5zY3JpYmVkIGkKICAgICAgICAgICAgICAgICAgICAgICAgSk9JTiB0YmxfcmF0aW5ncyByYQogICAgICAgICAgICAgICAgICAgICAgICBMRUZUIEpPSU4gdGJsX2NvdXJzZXMgYyBPTiBpLmlkX2NvdXJzZSA9IGMuaWRfY291cnNlIEFORCByYS5pZF9jb3Vyc2UgPSBjLmlkX2NvdXJzZQogICAgICAgICAgICAgICAgICAgICAgICBMRUZUIEpPSU4gdGJsX2F1dGhvciBhIE9OIGMuYXV0aG9yID0gYS5pZF9hdXRob3IKICAgICAgICAgICAgICAgICAgICAgICAgV0hFUkUgYS5pZF9hdXRob3I9PyBBTkQgaS5zdGF0dXM9PwogICAgICAgICAgICAgICAgICAgICAgICAiKTsKJHN0bXQtPmJpbmRfcGFyYW0oImlzIiwgJGF1dGhvciwgJHN0YXR1cyk7CiRzdG10LT5leGVjdXRlKCk7CiRzdG10LT5iaW5kX3Jlc3VsdCgkZW5yb2xsZWRfaW5zdHJ1Y3RvciwgJGF2Z19yYXRpbmcpOwokc3RtdC0+ZmV0Y2goKTsKJHN0bXQtPmNsb3NlKCk7