How to select the last date before an other date

[Anonymous]

Hello,

I'm having difficulty trying to get the last date of an activity compared to a date in a other table.

I have the following tables:

System

System	Test	Timestamp
Test_system_A	Test_cycle_1	2018-01-01 12:08:09
Test_system_A	Test_cycle_4	2018-01-03 11:08:49
Test_system_B	Test_cycle_3	2018-01-02 16:16:09
Test_system_A	Test_cycle_2	2018-01-05 08:08:19
Test_system_A	Test_cycle_9	2018-01-06 20:18:09

Config

System	Configuration	Timestamp
Test_system_A	config1a	2018-01-01 08:08:09
Test_system_A	config1b	2018-01-05 20:08:09
Test_system_B	config1a	2018-01-01 10:08:09

The report should show the number of test cycles have been performed on which system and configuration and when the last test cycle has been performed.

The outcome should look like this:

System	Configuration	Nbr of test cycles	Last test cycle performed
Test_system_A	config1a	3	2018-01-05 08:08:19
Test_system_A	config1b	1	2018-01-06 20:18:09
Test_system_B	config1a	1	2018-01-02 16:16:09

Is there a sollution for this situation?