info: 11/19/2026 09:45:45.105 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT COUNT(*) FROM "sqlite_master" WHERE "type" = 'table' AND "rootpage" IS NOT NULL;
info: 11/19/2026 09:45:45.173 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      CREATE TABLE "Courses" (
          "Code" TEXT NOT NULL CONSTRAINT "PK_Courses" PRIMARY KEY
      );
info: 11/19/2026 09:45:45.173 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      CREATE TABLE "Expected" (
          "Id" INTEGER NOT NULL CONSTRAINT "PK_Expected" PRIMARY KEY AUTOINCREMENT,
          "Code" TEXT NOT NULL,
          "Amount" INTEGER NOT NULL
      );
info: 11/19/2026 09:45:45.173 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      CREATE TABLE "Paid" (
          "Id" INTEGER NOT NULL CONSTRAINT "PK_Paid" PRIMARY KEY AUTOINCREMENT,
          "Code" TEXT NOT NULL,
          "Amount" INTEGER NOT NULL
      );
info: 11/19/2026 09:45:45.173 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      CREATE TABLE "Student" (
          "Id" INTEGER NOT NULL CONSTRAINT "PK_Student" PRIMARY KEY AUTOINCREMENT,
          "Name" TEXT NOT NULL,
          "CourseCode" TEXT NOT NULL,
          CONSTRAINT "FK_Student_Courses_CourseCode" FOREIGN KEY ("CourseCode") REFERENCES "Courses" ("Code") ON DELETE CASCADE
      );
info: 11/19/2026 09:45:45.173 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      CREATE INDEX "IX_Student_CourseCode" ON "Student" ("CourseCode");
info: 11/19/2026 09:45:45.292 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (2ms) [Parameters=[@p0='?' (Size = 4)], CommandType='Text', CommandTimeout='30']
      INSERT INTO "Courses" ("Code")
      VALUES (@p0);
info: 11/19/2026 09:45:45.294 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[@p0='?' (Size = 4)], CommandType='Text', CommandTimeout='30']
      INSERT INTO "Courses" ("Code")
      VALUES (@p0);
info: 11/19/2026 09:45:45.295 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (DbType = Int32), @p2='?' (Size = 4)], CommandType='Text', CommandTimeout='30']
      INSERT INTO "Expected" ("Id", "Amount", "Code")
      VALUES (@p0, @p1, @p2);
info: 11/19/2026 09:45:45.295 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (DbType = Int32), @p2='?' (Size = 4)], CommandType='Text', CommandTimeout='30']
      INSERT INTO "Expected" ("Id", "Amount", "Code")
      VALUES (@p0, @p1, @p2);
info: 11/19/2026 09:45:45.295 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (DbType = Int32), @p2='?' (Size = 4)], CommandType='Text', CommandTimeout='30']
      INSERT INTO "Paid" ("Id", "Amount", "Code")
      VALUES (@p0, @p1, @p2);
info: 11/19/2026 09:45:45.295 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (DbType = Int32), @p2='?' (Size = 4)], CommandType='Text', CommandTimeout='30']
      INSERT INTO "Paid" ("Id", "Amount", "Code")
      VALUES (@p0, @p1, @p2);
info: 11/19/2026 09:45:45.295 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (DbType = Int32), @p2='?' (Size = 4)], CommandType='Text', CommandTimeout='30']
      INSERT INTO "Paid" ("Id", "Amount", "Code")
      VALUES (@p0, @p1, @p2);
info: 11/19/2026 09:45:45.295 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[@p0='?' (Size = 4), @p1='?' (Size = 3)], CommandType='Text', CommandTimeout='30']
      INSERT INTO "Student" ("CourseCode", "Name")
      VALUES (@p0, @p1)
      RETURNING "Id";
info: 11/19/2026 09:45:45.300 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[@p0='?' (Size = 4), @p1='?' (Size = 3)], CommandType='Text', CommandTimeout='30']
      INSERT INTO "Student" ("CourseCode", "Name")
      VALUES (@p0, @p1)
      RETURNING "Id";
SQLite 3.53.3, EF 10.0.13.0
Report
SELECT "u"."Code", "u"."Expected", "u"."Paid"
FROM (
    SELECT "e0"."Code", "e0"."Amount" AS "Expected", COALESCE("p0"."Amount", 0) AS "Paid"
    FROM (
        SELECT "e"."Code", COALESCE(SUM("e"."Amount"), 0) AS "Amount"
        FROM "Expected" AS "e"
        GROUP BY "e"."Code"
    ) AS "e0"
    LEFT JOIN (
        SELECT "p"."Code", COALESCE(SUM("p"."Amount"), 0) AS "Amount"
        FROM "Paid" AS "p"
        GROUP BY "p"."Code"
    ) AS "p0" ON "e0"."Code" = "p0"."Code"
    UNION ALL
    SELECT "p1"."Code", 0 AS "Expected", COALESCE(SUM("p1"."Amount"), 0) AS "Paid"
    FROM "Paid" AS "p1"
    GROUP BY "p1"."Code"
    HAVING NOT EXISTS (
        SELECT 1
        FROM "Expected" AS "e1"
        GROUP BY "e1"."Code"
        HAVING "e1"."Code" = "p1"."Code")
) AS "u"
ORDER BY "u"."Code"
CO-ROUTINE u
COMPOUND QUERY
LEFT-MOST SUBQUERY
CO-ROUTINE e0
SCAN e
USE TEMP B-TREE FOR GROUP BY
MATERIALIZE p0
SCAN p
USE TEMP B-TREE FOR GROUP BY
SCAN e0
SEARCH p0 USING AUTOMATIC COVERING INDEX (Code=?) LEFT-JOIN
UNION ALL
SCAN p1
USE TEMP B-TREE FOR GROUP BY
CORRELATED SCALAR SUBQUERY 4
SCAN e1
USE TEMP B-TREE FOR GROUP BY
SCAN u
USE TEMP B-TREE FOR ORDER BY
info: 11/19/2026 09:45:45.471 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT "u"."Code", "u"."Expected", "u"."Paid"
      FROM (
          SELECT "e0"."Code", "e0"."Amount" AS "Expected", COALESCE("p0"."Amount", 0) AS "Paid"
          FROM (
              SELECT "e"."Code", COALESCE(SUM("e"."Amount"), 0) AS "Amount"
              FROM "Expected" AS "e"
              GROUP BY "e"."Code"
          ) AS "e0"
          LEFT JOIN (
              SELECT "p"."Code", COALESCE(SUM("p"."Amount"), 0) AS "Amount"
              FROM "Paid" AS "p"
              GROUP BY "p"."Code"
          ) AS "p0" ON "e0"."Code" = "p0"."Code"
          UNION ALL
          SELECT "p1"."Code", 0 AS "Expected", COALESCE(SUM("p1"."Amount"), 0) AS "Paid"
          FROM "Paid" AS "p1"
          GROUP BY "p1"."Code"
          HAVING NOT EXISTS (
              SELECT 1
              FROM "Expected" AS "e1"
              GROUP BY "e1"."Code"
              HAVING "e1"."Code" = "p1"."Code")
      ) AS "u"
      ORDER BY "u"."Code"
{ Code = C101, Expected = 2, Paid = 3 }
{ Code = C102, Expected = 1, Paid = 0 }
{ Code = C103, Expected = 0, Paid = 1 }
GroupBy
SELECT "p"."Code", COALESCE(SUM("p"."Amount"), 0) AS "Amount"
FROM "Paid" AS "p"
GROUP BY "p"."Code"
SCAN p
USE TEMP B-TREE FOR GROUP BY
Split SQL (first statement)
SELECT "c"."Code"
FROM "Courses" AS "c"
ORDER BY "c"."Code"

This LINQ query is being executed in split-query mode, and the SQL shown is for the first query to be executed. Additional queries may also be executed depending on the results of the first query.
SCAN c USING COVERING INDEX sqlite_autoindex_Courses_1
info: 11/19/2026 09:45:45.510 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT "c"."Code"
      FROM "Courses" AS "c"
      ORDER BY "c"."Code"
info: 11/19/2026 09:45:45.513 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT "s"."Id", "s"."CourseCode", "s"."Name", "c"."Code"
      FROM "Courses" AS "c"
      INNER JOIN "Student" AS "s" ON "c"."Code" = "s"."CourseCode"
      ORDER BY "c"."Code"
C101: 2
C102: 0
