/* Lotto -- sqlite at least v. 3.8 needed */

WITH cnt AS (
  SELECT 1 x 
  UNION 
  SELECT x + 1 
  FROM cnt 
  WHERE x < 40
)
SELECT x
FROM cnt 
ORDER BY RANDOM() 
LIMIT 7;