The SQL statements already have GROUP BY (see attached pdf that includes the SQL statement, database table and current result). I've also tried changing the GROUP BY column names to those in the foreign key table, but got the same result.
The second page of the pdf uses a similar query from the same database table. Is there a way to eliminate having the lubricant after every product, and just as a heading?