@commands.command()
    async def rank(self, ctx, member: discord.Member=None):
            member = member or ctx.author
            userguild = f'{member.id}'
            async with aiosqlite3.connect("C:/Users/runne/OneDrive/Desktop/dsbotaiosql/level.db") as db:
                async with db.execute("SELECT level FROM level WHERE userguild = ?", (userguild,)) as cursor1:
                    async with db.execute("SELECT xp FROM level WHERE userguild = ?", (userguild,)) as cursor2:
                        exp = await cursor2.fetchone()
                        level = await cursor1.fetchone()
                        async with db.execute("SELECT userguild, RANK() OVER(ORDER BY xp DESC) FROM level") as is1:
                            ids = await is1.fetchall()
                            await ctx.send(f"{member.display_name}'s rank is {ids[0]} of {len(ids)}")
                            embed = discord.Embed(title=f"{member}'s Level and Rank Info", color=0xffffff)
                            embed.add_field(name="User Level Info:", value=f'Username: **{member.name + "#" + member.discriminator}**\nLevel: **{level[0]}**\nXp: **{exp[0]}**\nRank: **{ids[0]} of {len(ids)}**', inline=False)
                            embed.set_thumbnail(url=member.avatar_url)
                            await ctx.send(embed=embed, delete_after=30)