Snap interview question

Simple SQL and stats / probability