I have to table with blow structures

**Meeting** 

* meetingID
* meetingDate
* meetingTitle

**MeetingPersion** the people who attend in Meetings

* id
* meetingID
* personID
* **IsPresent bit**

and this is sample rows for testing 

Meeting Table Rows

* meetingID:1 -- 2010/05/05 -- MeetingX
* meetingID:2 -- 2010/05/07 -- MeetingY

MeetingPerson Table Rows

```
MeetingID:2
PersonID:1
IsPresent:true

MeetingID:2
PersonID:2
IsPresent:true

MeetingID:2
PersonID:3
IsPresent:false

MeetingID:2
PersonID:4
IsPresent:null

```

I need to have query for showing in report and I need to have this result with sample date, title of reporsts

```
MeetingTitle | NumberOfPresent | NumberOfAbsents

```

the result of sample data shoud be like this 

```
Title:MeetingX | NumberOfPresent:0 | NumberOfAbsents:0
Title:MeetingY | NumberOfPresent:2 | NumberOfAbsents:1

```