Why would an all knowing God create humanity if he knew that they would sin?

This is a hard question. And tonight at AFW, we will talk about it. I keep thinking of Deuteronomy 29:29 where Moses writes that the there are mysteries about God that we cannot understand and that he has revealed part of who he is and we need to understand those revelations. I guess this may be one of those mysteries?

C.