SELECT Asynchronous with PYTHON

Question

Hello everyone, thank you!!

I am trying to make some connections to a Mysql database in asynchronous mode where there is dispute and print on the screen the result that arrives first... but I am not able to make it work...

import asyncio
import aiomysql

loop = asyncio.get_event_loop()

async def test_example():
    pool = await aiomysql.create_pool(host='',
                                port=3306,
                                user='administrator', 
                                password='',
                                db='sakila', 
                                loop=loop)

    pool2 = await aiomysql.create_pool(host='',
                                port=3306,
                                user='administrator', 
                                password='',
                                db='sakila', 
                                loop=loop)

    async with pool2.acquire() as conn2:
        async with conn2.cursor() as cur2:
            await cur2.execute("SELECT count(*) FROM filme")
            print(await cur2.fetchall())

    async with pool.acquire() as conn:
        async with conn.cursor() as cur:
            await cur.execute("SELECT count(*) FROM aluguel")
            print(await cur.fetchall())

    pool.close()
    pool2.close()
    await pool.wait_closed()

loop.run_until_complete(test_example())

this was the last code I arrived, trying to make two connections to the bank and 2 queries but the code that is above always arrives first.. Does anyone have any idea how I can make them compete ?