connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "
SELECT
pa.roll_no,
MAX(pa.last_attempt_at) AS last_practice_date
FROM practice_attempts pa
GROUP BY pa.roll_no
HAVING
MAX(pa.last_attempt_at) < NOW() - INTERVAL 10 DAY
ORDER BY last_practice_date ASC
LIMIT 25
";
$result = $conn->query($sql);
?>
Stalled Learners