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)
 );

CREATE TABLE


-- 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');

INSERT 0 30


with cte as(
  select 
   client,
   version,
   version_created_at,
   count(Sentence) total_count_of_sentences_per_version,
   row_number() over(partition by client order by version_created_at desc) version_row_number
 from model_versions
 group by
   client,version,
   version_created_at
 )
select
  client,
  version,
  total_count_of_sentences_per_version,
  version_created_at
from cte
where version_row_number <=3
 


client
version
total_count_of_sentences_per_version
version_created_at


es_client1
5
1
2021-05-01

es_client1
4
2
2021-04-01

es_client1
3
2
2021-03-01

es_client2
4
2
2021-05-01

es_client2
3
2
2021-04-01

es_client2
2
3
2021-03-01

es_client3
5
2
2021-10-01

es_client3
4
2
2021-08-01

es_client3
3
2
2021-07-01



SELECT 9

client	version	total_count_of_sentences_per_version	version_created_at
es_client1	5	1	2021-05-01
es_client1	4	2	2021-04-01
es_client1	3	2	2021-03-01
es_client2	4	2	2021-05-01
es_client2	3	2	2021-04-01
es_client2	2	3	2021-03-01
es_client3	5	2	2021-10-01
es_client3	4	2	2021-08-01
es_client3	3	2	2021-07-01