Persons
|id   |firstname|lastname|
|-----|---------|--------|
|1    |John     |Doe     |
|2    |Jim      |Smith   |
|3    |Jane     |Boggard |
|4    |Joe      |Dash    |

Licences
|p_id |licence|
|-----|-------|
|1    |car    |
|1    |bike   |
|2    |car    |
|3    |car    |
|3    |bike   |
|1    |plane  |
|4    |bike   |

select
    persons.id
  ,persons.firstname
  ,Persons.lastname
from Persons
    inner join Licenses on
        Licenses.p_id = Persons.`id`
group by
    persons.id
    ,persons.firstname
    ,persons.lastname
having
  count(*) = 1

select
    persons.id
  ,persons.firstname
  ,Persons.lastname
from Persons
    inner join Licenses on
        Licenses.p_id = Persons.`id`
group by
    persons.id
    ,persons.firstname
    ,persons.lastname
having
  count(*) = 1
  and min(licenses.licence) = 'car'