MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table Table_One (
  ID int, 
  Name varchar(20)
);

insert into Table_One values
(1 , 'John'),
(2 , 'Tom'),
(3 , 'Anna'); 

create table Table_two (
  ID int, 
  Visit_ID int,   
  Date date,
  read_reciept int
);


insert into Table_two values
(1 ,     2513 , '2001-05-05', 1),
(1 ,    84654 , '2012-10-05', 1), 
(1 ,      454 , '2018-04-20', 1), 
(2 ,      754 , '1999-04-05', 0),  
(2 ,      654 , '2010-08-08', 1),  
(2 ,      624 , '1982-04-09', 1),  
(3 ,     7546 , '1997-07-03', 0),  
(3 ,   246574 , '2015-06-04', 1),
(3 ,    15487 , '2017-03-04', 1);  

Records: 3  Duplicates: 0  Warnings: 0



Records: 9  Duplicates: 0  Warnings: 0


-- get max date per ID
select ID, MAX(Date) as max_date, sum(read_reciept) as read_reciept
from Table_two
group by ID


ID
max_date
read_reciept


1
2018-04-20
3

2
2010-08-08
2

3
2017-03-04
2


-- get the related Visit_ID and sum(read_reciept)
SELECT a.ID, a.Visit_ID, t.max_date, t.read_reciept
FROM Table_two a
INNER JOIN (
  select ID, MAX(Date) as max_date, sum(read_reciept) as read_reciept
  from Table_two
  group by ID
) as t on a.ID = t.ID and a.Date = t.max_date


ID
Visit_ID
max_date
read_reciept


1
454
2018-04-20
3

2
654
2010-08-08
2

3
15487
2017-03-04
2


SELECT a.ID, b.Name, a.Visit_ID, a.Date, t.read_reciept
FROM Table_two a
INNER JOIN Table_One b on a.ID = b.ID
INNER JOIN (
  select ID, MAX(Date) as max_date, sum(read_reciept) as read_reciept
  from Table_two
  group by ID
) as t on a.ID = t.ID and a.Date = t.max_date


ID
Name
Visit_ID
Date
read_reciept


1
John
454
2018-04-20
3

2
Tom
654
2010-08-08
2

3
Anna
15487
2017-03-04
2