Not sure but something like this should work
'meta_query' => array(
'relation' => 'AND',
array(
'key' => 'type_activity',
'value' => 'Sports',
'compare' => 'LIKE',
),
array(
'key' => 'type_activity',
'value' => 'Works',
'compare' => 'NOT LIKE',
),
),