info: 11/19/2026 09:45:47.480 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:47.546 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:47.547 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:47.547 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:47.547 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:47.547 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:47.647 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:47.649 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:47.650 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:47.650 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:47.650 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:47.650 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:47.650 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:47.651 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:47.655 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.4, EF 11.0.0.0
Report
SELECT COALESCE("e0"."Code", "p0"."Code") AS "Code", COALESCE("e0"."Amount", 0) 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"
FULL 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"
ORDER BY COALESCE("e0"."Code", "p0"."Code")
MATERIALIZE e0
SCAN e
USE TEMP B-TREE FOR GROUP BY
MATERIALIZE p0
SCAN p
USE TEMP B-TREE FOR GROUP BY
SCAN e0
SCAN p0 LEFT-JOIN
RIGHT-JOIN p0
SCAN p0
USE TEMP B-TREE FOR ORDER BY
info: 11/19/2026 09:45:47.798 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT COALESCE("e0"."Code", "p0"."Code") AS "Code", COALESCE("e0"."Amount", 0) 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"
      FULL 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"
      ORDER BY COALESCE("e0"."Code", "p0"."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:47.835 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:47.837 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
