mySQL

The table "activities" contains a log of activities by user and timestamp. activity timestamp username john activity1 2020-01-01 01:00:00 john activity 2 2020-01-01 02:00:00 john activity3 2020-01-01 03:00:00 jane activity1 2020-01-01 02:00:00 jane activity2 2020-01-01 03:00:00 jane activity3 2020-01-01 04:00:00 The table "clicks" contains a log of clicks by user and timestamp. clickid timestamp username john click1 2020-01-01 00:00:00 john click2 2020-01-01 01:30:00 john click3 2020-01-01 01:45:00 jane click1 2020-01-01 00:00:00 jane click2 2020-01-01 00:30:00 jane click3 2020-01-01 03:35:00 Please match all the activities in the activities table to the most recent click in the clicks table performed by each user. The click matched to each activity must be the most recent click that occurred prior to the activity timestamp. Please match all the activities in the activities table to the most recent click in the clicks table performed by each user. The click matched to each activity must be the most recent click that occurred prior to the activity timestamp. Expected Output: john activity 1 click1 john activity2 click3 john activity 3 click3 jane activity 1 click2 jane activity2 click2 jane activity 3 click3