我有3个模型：
class Organization(models.Model):
    name = models.CharField(max_length=250, unique=True)
    def __str__(self):
        return self.name 
class AppealForm(models.Model):
    form_name = models.CharField(max_length=100)
    def __str__(self):
        return self.form_name
class Appeal(models.Model):
    organization = models.ForeignKey(Organization, on_delete=models.SET_NULL, blank=True, null=True)
    appeal_form = models.ForeignKey(AppealForm, on_delete=models.CASCADE, blank=True, null=True)
    appeal_number = models.CharField(max_length=100, blank=True, null=True)
    applicant_first_name = models.CharField(max_length=100, blank=True, null=True)
    applicant_second_name = models.CharField(max_length=100, blank=True, null=True)
    date = models.DateField(blank=True, null=True)
    appeal_body = models.TextField()
模型的对象：
**Organization**
|#|name|
|-|-|
|1|苹果|
|2|三星|
|3|戴尔|
**AppealForm**
|#|form_name|
|-|-|
|1|书面|
|2|口头|
**Appeal**
|#|organization|appeal_form|appeal_number|applicant_first_name|applicant_second_name|date|appeal_body|
|-|-|-|-|-|-|-|-|
|1|苹果|书面|abc1|奥利弗|杰克|06/22/2023|测试上诉正文文本|
|2|苹果|口头|abc12|杰克|康纳|05/22/2023|测试上诉正文文本|
|3|苹果|口头|abc123|哈利|卡勒姆|04/22/2023|测试上诉正文文本|
|4|戴尔|书面|abc1234|查理|威廉|03/22/2023|测试上诉正文文本|
|5|戴尔|口头|abc12345|乔治|里斯|02/22/2023|测试上诉正文文本|
**我想从组织模型查询生成以下表格：**
| # | 组织 | 总上诉数量 | 书面上诉数量 | 口头上诉数量 |
| - | --- |--- |--- |--- |
| 1 | 苹果 | 3 | 1 | 2 |
| 2 | 三星 | 0 | 0 | 0 |
| 3 | 戴尔 | 2 | 1 | 1 |
*查询将是什么样子？*
提前感谢！
==========================================
**更新：**
*filters.py*
```python
class AppealFilter(django_filters.FilterSet):
    appeal__date = django_filters.DateFromToRangeFilter(widget=django_filters.widgets.RangeWidget(attrs={'type': 'date'}))
    class Meta:
        model = Organization
        fields = ['appeal__date']

Organization.objects.annotate(total_appeals=Count('appeal'), written_appeals=Count('appeal', filter=Q(appeal__appeal_form__form_name="written")),
oral_appeals=Count('appeal', filter=Q(appeal__appeal_form__form_name="Oral")))