Hi can you create a .net web api using entity framework based off of this postgres query?   SELECT
ch."ChapterId" as "chapterId",
ch."IsActive" as "isActive",
ch."NameEn" as "name",
ch."SortOrder" as "sortOrder",
ch."SubjectId" as "subjectId",
count(ls."MmLessonSetId") as mmLessonSetCount,
SUM(CASE WHEN ls."IsActive" = TRUE THEN 1 ELSE 0 END) as mmLessonSetActiveCount
FROM
"Chapters" as ch
LEFT JOIN
"MmLessonSets" as ls
ON
ls."ChapterId" = ch."ChapterId"
WHERE
ch."SubjectId" = 'SubjectId0011'
AND
ch."IsActive" = TRUE
GROUP BY
ch."ChapterId", ch."IsActive", ch."NameEn", ch."SortOrder", ch."SubjectId"
ORDER BY
ch."SortOrder"