I'd need to make a query where I get as a result two columns. One column is directly from one table, but the other one is a hit count from another column. The number of hits is the number of WHERE LIKE (thefirstcolumn).
So if we take this with a very simple example:
Mary had a lamb
John is a name
Mary and John are married
so the result from there should be like
but obviously I'm missing an aggregate function there.