There are 3 tables, HOUSE, CAR, ALL
HOUSE list has room
People have cars CAR list
ALL is total table, everyone in this HOUSE, tables and some people there must be a CAR list
The following

HOUSE table
The NAME ALIAS CORP DEPT
Zhang SAN zs oracle Beijing research and development department
Zhang SAN zs1 oracle Beijing finance department
Zhang SAN zs2 oracle Shanghai r&d
Li si ls oracle Shanghai finance department
Fifty and ww oracle Shanghai Marketing Department

CAR table
The NAME ALIAS CORP DEPT
Zhang SAN zs2 oracle Shanghai r&d
Li si ls oracle Shanghai finance department
Li si ls2 oracle research and development department of Hong Kong
Fifty and ww oracle Hong Kong financial department
Fifty ww2 oracle Hong Kong hr

ALL table
The NAME ALIAS CORP DEPT
Zhang SAN zs oracle Beijing research and development department
Zhang SAN zs1 oracle Beijing finance department
Zhang SAN zs2 oracle Shanghai r&d
Li si ls oracle Shanghai finance department
Li si ls1 oracle Shanghai Marketing Department
Li si ls2 oracle research and development department of Hong Kong
Fifty and ww oracle Hong Kong financial department
Fifty ww1 oracle Hong Kong marketing
Fifty ww2 oracle Hong Kong hr

How to find out what people have a room have a car?
What people don't have a car have room?
People who have a car didn't room?
What people don't have a car not room?