SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `results` (batch_id, workstation_id, result, received, log_time);
✓
WITH cte(n) AS (SELECT 1 UNION ALL SELECT n + 1 FROM cte WHERE n < 30)
INSERT INTO `results` (batch_id, workstation_id, result, received, log_time) 
SELECT 281, 
       13, 
       ABS(RANDOM()) % (232.91 - 69.87) + 69.87,
       DATETIME('now', n || ' day', 'localtime'),
       DATETIME('now', 'localtime')
FROM cte;
✓
SELECT * FROM results;


batch_id
workstation_id
result
received
log_time


281
13
211.87
2023-12-28 23:47:18
2023-12-27 23:47:18

281
13
142.87
2023-12-29 23:47:18
2023-12-27 23:47:18

281
13
97.87
2023-12-30 23:47:18
2023-12-27 23:47:18

281
13
136.87
2023-12-31 23:47:18
2023-12-27 23:47:18

281
13
133.87
2024-01-01 23:47:18
2023-12-27 23:47:18

281
13
74.87
2024-01-02 23:47:18
2023-12-27 23:47:18

281
13
228.87
2024-01-03 23:47:18
2023-12-27 23:47:18

281
13
142.87
2024-01-04 23:47:18
2023-12-27 23:47:18

281
13
70.87
2024-01-05 23:47:18
2023-12-27 23:47:18

281
13
207.87
2024-01-06 23:47:18
2023-12-27 23:47:18

281
13
173.87
2024-01-07 23:47:18
2023-12-27 23:47:18

281
13
78.87
2024-01-08 23:47:18
2023-12-27 23:47:18

281
13
127.87
2024-01-09 23:47:18
2023-12-27 23:47:18

281
13
146.87
2024-01-10 23:47:18
2023-12-27 23:47:18

281
13
162.87
2024-01-11 23:47:18
2023-12-27 23:47:18

281
13
180.87
2024-01-12 23:47:18
2023-12-27 23:47:18

281
13
154.87
2024-01-13 23:47:18
2023-12-27 23:47:18

281
13
126.87
2024-01-14 23:47:18
2023-12-27 23:47:18

281
13
205.87
2024-01-15 23:47:18
2023-12-27 23:47:18

281
13
130.87
2024-01-16 23:47:18
2023-12-27 23:47:18

281
13
91.87
2024-01-17 23:47:18
2023-12-27 23:47:18

281
13
188.87
2024-01-18 23:47:18
2023-12-27 23:47:18

281
13
192.87
2024-01-19 23:47:18
2023-12-27 23:47:18

281
13
109.87
2024-01-20 23:47:18
2023-12-27 23:47:18

281
13
218.87
2024-01-21 23:47:18
2023-12-27 23:47:18

281
13
154.87
2024-01-22 23:47:18
2023-12-27 23:47:18

281
13
183.87
2024-01-23 23:47:18
2023-12-27 23:47:18

281
13
223.87
2024-01-24 23:47:18
2023-12-27 23:47:18

281
13
158.87
2024-01-25 23:47:18
2023-12-27 23:47:18

281
13
190.87
2024-01-26 23:47:18
2023-12-27 23:47:18

batch_id	workstation_id	result	received	log_time
281	13	211.87	2023-12-28 23:47:18	2023-12-27 23:47:18
281	13	142.87	2023-12-29 23:47:18	2023-12-27 23:47:18
281	13	97.87	2023-12-30 23:47:18	2023-12-27 23:47:18
281	13	136.87	2023-12-31 23:47:18	2023-12-27 23:47:18
281	13	133.87	2024-01-01 23:47:18	2023-12-27 23:47:18
281	13	74.87	2024-01-02 23:47:18	2023-12-27 23:47:18
281	13	228.87	2024-01-03 23:47:18	2023-12-27 23:47:18
281	13	142.87	2024-01-04 23:47:18	2023-12-27 23:47:18
281	13	70.87	2024-01-05 23:47:18	2023-12-27 23:47:18
281	13	207.87	2024-01-06 23:47:18	2023-12-27 23:47:18
281	13	173.87	2024-01-07 23:47:18	2023-12-27 23:47:18
281	13	78.87	2024-01-08 23:47:18	2023-12-27 23:47:18
281	13	127.87	2024-01-09 23:47:18	2023-12-27 23:47:18
281	13	146.87	2024-01-10 23:47:18	2023-12-27 23:47:18
281	13	162.87	2024-01-11 23:47:18	2023-12-27 23:47:18
281	13	180.87	2024-01-12 23:47:18	2023-12-27 23:47:18
281	13	154.87	2024-01-13 23:47:18	2023-12-27 23:47:18
281	13	126.87	2024-01-14 23:47:18	2023-12-27 23:47:18
281	13	205.87	2024-01-15 23:47:18	2023-12-27 23:47:18
281	13	130.87	2024-01-16 23:47:18	2023-12-27 23:47:18
281	13	91.87	2024-01-17 23:47:18	2023-12-27 23:47:18
281	13	188.87	2024-01-18 23:47:18	2023-12-27 23:47:18
281	13	192.87	2024-01-19 23:47:18	2023-12-27 23:47:18
281	13	109.87	2024-01-20 23:47:18	2023-12-27 23:47:18
281	13	218.87	2024-01-21 23:47:18	2023-12-27 23:47:18
281	13	154.87	2024-01-22 23:47:18	2023-12-27 23:47:18
281	13	183.87	2024-01-23 23:47:18	2023-12-27 23:47:18
281	13	223.87	2024-01-24 23:47:18	2023-12-27 23:47:18
281	13	158.87	2024-01-25 23:47:18	2023-12-27 23:47:18
281	13	190.87	2024-01-26 23:47:18	2023-12-27 23:47:18