querrying these three tables : want to query these three tables and count the number of household in a community that have machinery id of 1 from these three 
tables machinery [hhmachineryid -      hhid                - machineryid]
                     1            10-10-009-0001                7
                     1           10-07-005-0001                7
                     2            10-02-054-0001                3

household table [       hhid-         hh_comm_code ] 

                   10-01-001-0001        10-01-001
                   10-01-001-0002        10-01-001
                 
community table [ communitycode   -       community]
                   10-01-001              sekondi
