Problem with GROUP BY

System: Windows 10, LO (x64), Firebird
Hi. I’m having strange problems with GROUP BY. I’m following an [online tutorial] Video 29. His query, which works:
image description.

But when I try to replicate with my table, I get an error:

Any help offered is welcome.

Link above didn’t work. This is it: LibreOffice: Base - Homepage


Not all functionality is set for using Firebird (especially concerning older videos)

Set the first column table name to (no table)

Best to use SQL instead of the graphic interface.

Wow! I’d never have thought of that. Thanks Ratslinger.