I’m using Oracle 21C. I have a query that select from 3 tables and works fine with “hard-coded” dates.

I have data with 4 columns. A date column, Full Name column, Hours Worked column and a Memo column. The first three columns all contain data but the last (Memo) is often blank. I want to build a pivot table that sums the values of the hours for each name and filter to show only those under 40 total. I then want to show all the Memos for each person in the filtered list and do not want to show blanks. Attached is an image of a very simplified version.