@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, xp FROM level WHERE userguild = ?", (userguild,)) as cursor:
                    levelxp = await cursor.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: **{levelxp[0]}**\nXp: **{levelxp[1]}**\nRank: **{ids[0]} of {len(ids)}**', inline=False)
                embed.set_thumbnail(url=member.avatar_url)
                await ctx.send(embed=embed, delete_after=30)