Explore the AND condition in MySQL queries through practical examples.