Query error in Django with mysql

The issue in your Django query is with the filter syntax. You have level+in=[0, 1] but it should be level__in=[0, 1].
corrected code:
 

results = (
    Table.objects
    .filter(level__in=[0, 1])
    .values('datetime')
    .annotate(
        count_status_0=Count('id', filter=Q(level=0)),
        count_status_1=Count('id', filter=Q(level=1))
    )
    .order_by('datetime')
)

how to get the result of seperete scount of level 0, 1 

results = (

    Table.objects

    .filter(level__in=[0, 1])

    .values('datetime')

    .annotate(

        count_status_0=Count('id', filter=Q(level=0)),

        count_status_1=Count('id', filter=Q(level=1))      

    )

    .order_by('datetime')

)

Here level+in not a correct synex in django pyhton instead use level__in

 

from django.db.models import Count, Q

 

results = (

    Table.objects

    .filter(level__in=[0, 1])

    .values('datetime')

    .annotate(

        count_status_0=Count('id', filter=Q(level=0)),

        count_status_1=Count('id', filter=Q(level=1))      

    )

    .order_by('datetime')

)