Snap Interview Question

Simple SQL and stats / probability