Postgres 14

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

-- creating the model verisons table --
 create table model_versions
 (
 intent_id int,
 intent_name varchar(50),
 version int,
 version_created_at date,
 client varchar(50),
 sentence varchar(50)
 );
-- inserting data into model_verions table --
insert into model_versions values
(1,'a_intent',1,'2021-01-01','es_client1','sentence_1'),
(1,'a_intent',1,'2021-01-01','es_client1','sentence_2'),
(1,'a_intent',1,'2021-01-01','es_client1','sentence_3'),
(2,'b_intent',2,'2021-02-01','es_client1','sentence_1'),
(2,'b_intent',2,'2021-02-01','es_client1','sentence_2'),
(2,'b_intent',2,'2021-02-01','es_client1','sentence_3'),
(3,'c_intent',3,'2021-03-01','es_client1','sentence_1'),
(3,'c_intent',3,'2021-03-01','es_client1','sentence_2'),
(4,'d_intent',4,'2021-04-01','es_client1','sentence_1'),
(4,'d_intent',4,'2021-04-01','es_client1','sentence_2'),
(5,'e_intent',5,'2021-05-01','es_client1','sentence_1'),
(6,'g_intent',1,'2021-01-01','es_client2','sentence_1'),
(6,'g_intent',1,'2021-01-01','es_client2','sentence_2'),
(7,'h_intent',2,'2021-03-01','es_client2','sentence_1'),
(7,'h_intent',2,'2021-03-01','es_client2','sentence_2'),
(7,'h_intent',2,'2021-03-01','es_client2','sentence_3'),
(8,'i_intent',3,'2021-04-01','es_client2','sentence_1'),
(8,'i_intent',3,'2021-04-01','es_client2','sentence_2'),
(9,'j_intent',4,'2021-05-01','es_client2','sentence_1'),
(9,'j_intent',4,'2021-05-01','es_client2','sentence_2'),
(10,'k_intent',1,'2021-01-01','es_client3','sentence_1'),
(10,'k_intent',1,'2021-01-01','es_client3','sentence_2'),
(11,'k_intent',2,'2021-06-01','es_client3','sentence_1'),
(11,'k_intent',2,'2021-06-01','es_client3','sentence_2'),
(12,'k_intent',3,'2021-07-01','es_client3','sentence_1'),
(12,'k_intent',3,'2021-07-01','es_client3','sentence_2'),
(13,'k_intent',4,'2021-08-01','es_client3','sentence_1'),
(13,'k_intent',4,'2021-08-01','es_client3','sentence_2'),
(14,'k_intent',5,'2021-10-01','es_client3','sentence_1'),
(14,'k_intent',5,'2021-10-01','es_client3','sentence_2');
30 rows affected

select * from model_versions;


intent_id
intent_name
version
version_created_at
client
sentence


1
a_intent
1
2021-01-01
es_client1
sentence_1

1
a_intent
1
2021-01-01
es_client1
sentence_2

1
a_intent
1
2021-01-01
es_client1
sentence_3

2
b_intent
2
2021-02-01
es_client1
sentence_1

2
b_intent
2
2021-02-01
es_client1
sentence_2

2
b_intent
2
2021-02-01
es_client1
sentence_3

3
c_intent
3
2021-03-01
es_client1
sentence_1

3
c_intent
3
2021-03-01
es_client1
sentence_2

4
d_intent
4
2021-04-01
es_client1
sentence_1

4
d_intent
4
2021-04-01
es_client1
sentence_2

5
e_intent
5
2021-05-01
es_client1
sentence_1

6
g_intent
1
2021-01-01
es_client2
sentence_1

6
g_intent
1
2021-01-01
es_client2
sentence_2

7
h_intent
2
2021-03-01
es_client2
sentence_1

7
h_intent
2
2021-03-01
es_client2
sentence_2

7
h_intent
2
2021-03-01
es_client2
sentence_3

8
i_intent
3
2021-04-01
es_client2
sentence_1

8
i_intent
3
2021-04-01
es_client2
sentence_2

9
j_intent
4
2021-05-01
es_client2
sentence_1

9
j_intent
4
2021-05-01
es_client2
sentence_2

10
k_intent
1
2021-01-01
es_client3
sentence_1

10
k_intent
1
2021-01-01
es_client3
sentence_2

11
k_intent
2
2021-06-01
es_client3
sentence_1

11
k_intent
2
2021-06-01
es_client3
sentence_2

12
k_intent
3
2021-07-01
es_client3
sentence_1

12
k_intent
3
2021-07-01
es_client3
sentence_2

13
k_intent
4
2021-08-01
es_client3
sentence_1

13
k_intent
4
2021-08-01
es_client3
sentence_2

14
k_intent
5
2021-10-01
es_client3
sentence_1

14
k_intent
5
2021-10-01
es_client3
sentence_2

intent_id	intent_name	version	version_created_at	client	sentence
1	a_intent	1	2021-01-01	es_client1	sentence_1
1	a_intent	1	2021-01-01	es_client1	sentence_2
1	a_intent	1	2021-01-01	es_client1	sentence_3
2	b_intent	2	2021-02-01	es_client1	sentence_1
2	b_intent	2	2021-02-01	es_client1	sentence_2
2	b_intent	2	2021-02-01	es_client1	sentence_3
3	c_intent	3	2021-03-01	es_client1	sentence_1
3	c_intent	3	2021-03-01	es_client1	sentence_2
4	d_intent	4	2021-04-01	es_client1	sentence_1
4	d_intent	4	2021-04-01	es_client1	sentence_2
5	e_intent	5	2021-05-01	es_client1	sentence_1
6	g_intent	1	2021-01-01	es_client2	sentence_1
6	g_intent	1	2021-01-01	es_client2	sentence_2
7	h_intent	2	2021-03-01	es_client2	sentence_1
7	h_intent	2	2021-03-01	es_client2	sentence_2
7	h_intent	2	2021-03-01	es_client2	sentence_3
8	i_intent	3	2021-04-01	es_client2	sentence_1
8	i_intent	3	2021-04-01	es_client2	sentence_2
9	j_intent	4	2021-05-01	es_client2	sentence_1
9	j_intent	4	2021-05-01	es_client2	sentence_2
10	k_intent	1	2021-01-01	es_client3	sentence_1
10	k_intent	1	2021-01-01	es_client3	sentence_2
11	k_intent	2	2021-06-01	es_client3	sentence_1
11	k_intent	2	2021-06-01	es_client3	sentence_2
12	k_intent	3	2021-07-01	es_client3	sentence_1
12	k_intent	3	2021-07-01	es_client3	sentence_2
13	k_intent	4	2021-08-01	es_client3	sentence_1
13	k_intent	4	2021-08-01	es_client3	sentence_2
14	k_intent	5	2021-10-01	es_client3	sentence_1
14	k_intent	5	2021-10-01	es_client3	sentence_2