Advance Query of MySql

Hello Friends!
Can you please list out the difficult query regarding the MySql.
Actually i am working with database and need some awesome query .
So,please help me.

<snip>

please, you show us your database first, then we’ll show you the awesome query