MySQL Query - Select most recent configuration and most recent action
===

I really need help solving this problem with a single query.

I have four tables:

    [Assets]
    [id | serial_number | date_created] (other stuff)
    
    [Parts]
    [id | unit_number | date_created] (other stuff)

    [Groups]
    [id | asset_id | part_id | date_created] (other stuff)

    [Activity]
    [id | group_id | date_recorded | action_id] (other stuff)

How can I select all the assets and find their most recent pairing (group) and within that group their latest activity. In one record row.

Please help :(