-- Database schema
| state : StateCode [ TEXT ] primary_key , State [ TEXT ] , Region [ TEXT ] | callcenterlogs : Date received [ DATE ] , Complaint ID [ TEXT ] primary_key , rand client [ TEXT ] callcenterlogs.rand client = client.client_id , phonefinal [ TEXT ] , vru+line [ TEXT ] , call_id [ INTEGER ] , priority [ INTEGER ] , type [ TEXT ] , outcome [ TEXT ] , server [ TEXT ] , ser_start [ TEXT ] , ser_exit [ TEXT ] , ser_time [ TEXT ] | client : client_id [ TEXT ] primary_key , sex [ TEXT ] , day [ INTEGER ] , month [ INTEGER ] , year [ INTEGER ] , age [ INTEGER ] , social [ TEXT ] , first [ TEXT ] , middle [ TEXT ] , last [ TEXT ] , phone [ TEXT ] , email [ TEXT ] , address_1 [ TEXT ] , address_2 [ TEXT ] , city [ TEXT ] , state [ TEXT ] , zipcode [ INTEGER ] , district_id [ INTEGER ] client.district_id = district.district_id | district : district_id [ INTEGER ] primary_key , city [ TEXT ] , state_abbrev [ TEXT ] district.state_abbrev = state.StateCode , division [ TEXT ] | events : Date received [ DATE ] , Product [ TEXT ] , Sub-product [ TEXT ] , Issue [ TEXT ] , Sub-issue [ TEXT ] , Consumer complaint narrative [ TEXT ] , Tags [ TEXT ] , Consumer consent provided? [ TEXT ] , Submitted via [ TEXT ] , Date sent to company [ TEXT ] , Company response to consumer [ TEXT ] , Timely response? [ TEXT ] , Consumer disputed? [ TEXT ] , Complaint ID [ TEXT ] events.Complaint ID = callcenterlogs.Complaint ID , Client_ID [ TEXT ] events.Client_ID = client.client_id | reviews : Date [ DATE ] primary_key , Stars [ INTEGER ] , Reviews [ TEXT ] , Product [ TEXT ] , district_id [ INTEGER ] reviews.district_id = district.district_id |
-- -- Among the clients in Middle Atlantic, how many are them are female and no more than 18 years old?

SELECT COUNT(T1.sex) FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T2.division = 'Middle Atlantic' AND T1.sex = 'Female' AND T1.age < 18;