"SELECT COUNT(*) FROM table WHERE numeric_column < 
  (SELECT numeric_column FROM table WHERE your_criteria)"