SELECT ep.schedstatus, bk.LDate, ce.Comments, c.clientid, 
c.LastName,es.EvStrName 'Run',  
ep.City 'P/U City', p.polyname 'P/U County',
ed.City 'Drop-off City',
ed.AddrName 'Facility Name'  
                                                                                                                
FROM Events ep, Events ed, EventStrings es, Clients c, 
BookingLegs bl, Booking bk, polygons p, address a,
ClientEligConditions ce 
                                                 
WHERE ep.schedstatus = 3 AND ep.SchId > 288 and ep.SchId < 654 
AND ed.SchId = ep.SchId AND ep.Activity = 0 AND ed.Activity = 1   
AND   ed.BookingId = ep.BookingId AND es.SchId = ep.SchId 
AND es.EvStrId = ep.EvStrId     
AND c.ClientId = ep.ClientId 
AND ep.ClientId = ce.ClientId
AND bl.LegId = ep.LegId 
and a.AddrType = CH
and c.DateofBirth > 19871231 and c.DateofBirth < 19940101 
and a.jurispolyid in ('3', '4','7','43','66')            
and a.jurispolyid = p.polyid  
AND ed.BookingId = bk.BookingId  
                                      
ORDER BY c. DateofBirth, p.polyname, bk.LDate, es.EvStrName
 
              
The SQL Query listed above was created from putting together elements 
Of other existing SQL queries from the Kid One Transport database.
 
Trial and error methodology was used since no data dictionary was made 
available at the time the query was written.
 
                  Management Report Summary
 
After running this SQL query the results were as follows:

The date filter
(DOB > 19871231 and DOB < 19940101) shows 23
prenatal clients transported in the age range of 14-17 years old during
the 2005 calendar year. 
 
The SQL code to isolate the 2005 calendar year was:
            
          ep.SchId > 288 and ep.SchId < 654 
 
A total of 255 trips were made in 2005 by these 23 clients, some had 
more trips than others.