title: sql query for finding prime numbers
body: <p>Suppose I have numbers from 1 to 100 in a table.
  I need to write a query to extract all the prime numbers from this table. how can I achieve this with a very basic and simple query without using any sort of procedures or loops.</p>