cell
| CELL_ID | CELL_NAME |

animal
| ANIMAL_ID | ANIMAL_NAME |

cell_animal
| CELL_ID | ANIMAL_ID |

SELECT a.CELL_NAME, b.ANIMAL_NAME
FROM cell a, animal b, cell_animal c
WHERE
c.CELL_ID=a.CELL_ID
AND
b.ANIMAL_ID=c.ANIMAL_ID
ORDER BY b.ANIMAL_ID, b.CELL_ID