The cinematography and special effects in the movie "300" was really amazing.

The "oracle" scene was shot both above and below water, in different lighting conditions, all requiring that in edit, the models skin color was the same in every shot, and bubbles from her nose, hair, skin etc, were all removed in post.

All groundbreaking work where you can read about how they did the scene here or watch the below video.