title: SQL Find occurrences of value in a table regardless of columns
body: <p>I was recently asked in a interview how would I get count of apples, bananas and oranges in a table regardless of column information. The interviewer asked to provide counts of occurrences of apples and bananas and skip oranges.. </p>
  
  <p>I have never done a query before without column name, please help..</p>
  
  <p>thx</p>