I can't figure out how to extract data from the table below with an SQL statement with multiple conditions. Take for example the below table
The above three people Bob, Sam and Ricahrd have different dollar amounts by their names which this table is generated already by a query. Ricahrd has two entries with no dollar amount by his name.. I need to write something that just returns Bob and Sam and not Richard since his name does not have a dollar amount by each entry.