I have a table containing information for students.
Id           PupilId     Class      Date           Group
1            10           Class 1   2022-12-09               
2            12           Class 5   2022-12-09
3            80           Class 1   2022-12-09 Groupname
4            86          Class 1   2022-12-09 Groupname
5            90           Class 1   2022-12-09 Groupname
6            60           Class 1   2022-12-09 New Group 
7            72           Class 1   2022-12-09 New Group 
There is a field (pupilgroup="Testgroup" ) used to group the 50 students if they are in a group and if they aren't in a group its blank.
In SQL How do I display all students by date not in a group and only 1 from the TestGroup.
I would like it to display the Description for (student name, Class, room), show Group (blank) for the students not in a group and student name (blank), Class (Blank), room (blank), Group (Description) for the single entry.