Untitled

SELECT student_id , min(device_id) as 'device_id' from online_class_situations where course_number>0 group by student_id having min(date);

select student_id, device_id from online_class_situations where (student_id,date) in (select student_id,min(date) as date from online_class_situations where course_number>0 group by student_id);