Untitled

Query doesn't show all the results that I need
+--------+--------+--------+--------+
|  Name  |Building|   Nr   |  Time  |
+--------+--------+--------+--------+
| Tim    | House  |   30   |  10:10 |
| Jill   | House  |   31   |  10:20 |
| Tim    | Flat   |   31   |  10:30 |
| NULL   | Tower  |  NULL  |  NULL  |
| Jack   | Hut    |   32   |  10:50 |
| Jane   | Cabin  |   35   |  10:60 |
| Susan  | Cabin  |   35   |  11:70 |
+--------+--------+--------+--------+

SELECT * FROM `People` WHERE Name="Tim"

+--------+--------+--------+--------+
|  Name  |Building|   Nr   |  Time  |
+--------+--------+--------+--------+
| Tim    | House  |   30   |  10:10 |
| Tim    | Flat   |   31   |  10:30 |

+--------+--------+--------+--------+
|  Name  |Building|   Nr   |  Time  |
+--------+--------+--------+--------+
| Tim    | House  |   30   |  10:10 |
| Tim    | Flat   |   31   |  10:30 |
| NULL   | Tower  |  NULL  |  NULL  |
| NULL   | Hut    |  NULL  |  NULL  |
| NULL   | Cabin  |  NULL  |  NULL  |
+--------+--------+--------+--------+

SELECT * FROM `People` WHERE Name="Tim" OR Name is NULL

+--------+--------+--------+--------+
|  Name  |Building|   Nr   |  Time  |
+--------+--------+--------+--------+
| Tim    | House  |   30   |  10:10 |
| Tim    | Flat   |   31   |  10:30 |
| NULL   | Tower  |  NULL  |  NULL  |
+--------+--------+--------+--------+

| NULL   | Hut    |  NULL  |  NULL  |
 | NULL   | Cabin  |  NULL  |  NULL  |

select * from people where Name = 'Tim'
union
select 'NULL', Building, NULL, NULL from   people where Name != 'Tim';

SELECT Name, Building, Nr, Time FROM People WHERE Name = 'Tim'

UNION

SELECT DISTINCT NULL, Building, NULL, NULL FROM People WHERE Building NOT IN (SELECT Building FROM People WHERE Name = 'Tim')

SELECT * FROM `People` WHERE `Name`="Tim" OR `Name` is NULL OR `Name`='NULL' OR `NAME`=''

SELECT IF(Name='Tim',Name,NULL) AS Name,
       Building,
       IF(Name='Tim',Nr,NULL) AS Nr,
       IF(Name='Tim',Time,NULL) AS Time
FROM People ;