🌱 Random samples in sql

more random results vs speed

SAMPLING METHOD	TIMING
random()	205ms
BERNOULLI	54ms
SYSTEM	13ms

Example returning 1% of the data in tableName

SELECT
  *
FROM
  tableName TABLESAMPLE BERNOULLI(1);