My bowl game happens to be between Postgre and MySQL. My development environment MySQL instance and Heroku's Postgre are very different with aggregate functions

My bowl game happens to be between Postgre and MySQL. My development environment MySQL instance and Heroku's Postgre are very different with aggregate functions. i.e. How can I possibly select parent rows where ALL children match a certain criteria.