Instead, you would split this out into a proper_name table, which then has records mapping informal names to formal names. (Mike: Michael, Chris: Christopher, etc) You could then join that to the ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...