将基本的SQL查询转换为django orm

Question

我想在表中显示课程名称以及问题数。需要帮助将以下查询转换为django orm：

SELECT DISTINCT exam_course.course_name,
                COUNT(exam_question.question)
FROM exam_course
INNER JOIN exam_question ON exam_question.course_id = exam_course.id
GROUP BY exam_question.course_id

Answer 1

使用注释与注释的注释...以这种方式使用，相应地替换您的要求：

invoices = Invoice.objects.annotate(total_amount=Sum('order__order_items__amount'),number_of_invoices=Count('pk', distinct=True))