How many brightest cluster galaxies are also central cluster galaxies at low redshifts
For GAMA groups with Ngal > 4 and 0.02 < z < 0.1, how many brightest cluster galaxies are also central cluster galaxies.
This case requires bounds on variables within the same table. Look into the Schema Browser to find a suitable survey.
SELECT t1.GroupID, t1.Nfof, t1.IterCenCATAID, t1.Zfof, t1.BCGCATAID
From G3CFoFgroup as t1
Where t1.Zfof BETWEEN 0.02 and 0.1
AND t1.Nfof > 4