/* VICTORIA INSTITUTIONS — SQL course pages (same design as the Python and JavaScript courses) */

:root {
  --vi-blue: #2c3e8f;
  --vi-blue-dark: #1a2d7a;
  --vi-gold: #ffd580;
  --ink: #1e2233;
  --muted: #5b6078;
  --bg: #f4f5fb;
  --paper: #ffffff;
  --line: #dde2f5;
  --tint: #eef0ff;
  --accent: #2c3e8f;
  --code-bg: #f7f8fc;
  --code-ink: #1b2040;
  --out-bg: #10162e;
  --out-ink: #e4e8ff;
  --out-err: #ff9d9d;
  --good: #1f7a45;
  --good-bg: #e7f6ec;
  --bad: #a3361f;
  --bad-bg: #fdf0ec;
  --diff: rgba(255, 213, 128, 0.28);
  --warn-bg: #fff6de;
  --focus: #6d82ff;
  --sans: Arial, "Helvetica Neue", Helvetica, sans-serif;
  --serif: Georgia, "Noto Serif", "Times New Roman", serif;
  --mono: "JetBrains Mono", Consolas, "Courier New", monospace;
}
@media (prefers-color-scheme: dark) {
  :root:not([data-theme="light"]) {
    color-scheme: dark;
    --ink: #e4e7f5;
    --muted: #a4aac6;
    --bg: #11152a;
    --paper: #181d36;
    --line: #2d3561;
    --tint: #212a55;
    --accent: #a9b8ff;
    --code-bg: #0f1428;
    --code-ink: #e4e8ff;
    --out-bg: #0a0e1f;
    --good: #7fdca3;
    --good-bg: #173327;
    --bad: #ffab96;
    --bad-bg: #3a1e1a;
    --warn-bg: #3a3218;
  }
}
:root[data-theme="dark"] {
  color-scheme: dark;
  --ink: #e4e7f5;
  --muted: #a4aac6;
  --bg: #11152a;
  --paper: #181d36;
  --line: #2d3561;
  --tint: #212a55;
  --accent: #a9b8ff;
  --code-bg: #0f1428;
  --code-ink: #e4e8ff;
  --out-bg: #0a0e1f;
  --good: #7fdca3;
  --good-bg: #173327;
  --bad: #ffab96;
  --bad-bg: #3a1e1a;
  --warn-bg: #3a3218;
}

* { box-sizing: border-box; }
body {
  margin: 0;
  font-family: var(--serif);
  font-size: 18px;
  line-height: 1.7;
  color: var(--ink);
  background: var(--bg);
}

/* Top bar, matching the main site */
.top-bar {
  background: var(--vi-blue);
  padding: 10px 24px;
  padding-top: calc(10px + env(safe-area-inset-top, 0px));
  display: flex;
  align-items: center;
  justify-content: space-between;
  position: sticky;
  top: 0;
  z-index: 50;
  box-shadow: 0 1px 0 rgba(0, 0, 0, 0.15);
  gap: 16px;
  flex-wrap: wrap;
}
.top-bar-logo img { height: 42px; width: auto; display: block; }
.top-bar-nav { display: flex; gap: 20px; font-family: var(--sans); font-size: 14px; flex-wrap: wrap; }
.top-bar-nav a { color: #ccd6ff; text-decoration: none; }
.top-bar-nav a:hover { color: #fff; }
/* Course button in the nav bar — always visible on every lesson page so a
   reader can get back to the course's Contents / enroll page from anywhere,
   the same way read.php's nav always has a "Free Books" button. Added
   2026-09-28 at VED's instruction. */
.nav-course-btn {
  background: var(--vi-gold);
  color: #1a1a1a !important;
  padding: 5px 12px;
  border-radius: 5px;
  font-weight: 600;
}
.nav-course-btn:hover { background: #ffdf9e; color: #1a1a1a !important; }

/* Lesson header */
.lesson-head {
  background: linear-gradient(135deg, var(--vi-blue) 0%, var(--vi-blue-dark) 70%, #0f1f5c 100%);
  color: #fff;
  padding: 28px 16px 26px;
}
.lesson-head-inner { max-width: 760px; margin: 0 auto; }
.crumbs { font-family: var(--sans); font-size: 13px; color: #ccd6ff; margin: 0 0 10px; }
.crumbs a { color: #ccd6ff; }
.lesson-head h1 {
  font-weight: normal;
  font-size: clamp(1.7rem, 4.5vw, 2.4rem);
  line-height: 1.25;
  margin: 0 0 8px;
  text-wrap: balance;
}
.lesson-meta { font-family: var(--sans); font-size: 14px; color: #dfe5ff; margin: 0 0 16px; }
.lesson-meta .pill {
  display: inline-block;
  background: var(--vi-gold);
  color: var(--vi-blue-dark);
  font-weight: bold;
  font-size: 11px;
  letter-spacing: 0.06em;
  text-transform: uppercase;
  padding: 2px 9px;
  border-radius: 10px;
  margin-right: 8px;
  vertical-align: 1px;
}
.head-row { display: flex; flex-wrap: wrap; gap: 10px 18px; align-items: center; }

.lesson-progress { font-family: var(--sans); font-size: 13px; display: flex; align-items: center; gap: 10px; }
.prog-track { width: 140px; height: 8px; border-radius: 4px; background: rgba(255, 255, 255, 0.22); overflow: hidden; }
.prog-fill { height: 100%; width: 0; background: var(--vi-gold); transition: width 0.4s; }
.lesson-progress.on-paper .prog-track { background: var(--tint); }
.lesson-progress.on-paper .prog-fill { background: var(--vi-blue); }

.engine-status { font-family: var(--sans); font-size: 12.5px; color: #dfe5ff; }
.engine-status::before {
  content: "";
  display: inline-block;
  width: 8px; height: 8px;
  border-radius: 50%;
  margin-right: 6px;
  background: #9aa3c8;
  vertical-align: 1px;
}
.engine-status[data-state="loading"]::before { background: var(--vi-gold); animation: pulse 1s infinite alternate; }
.engine-status[data-state="ready"]::before { background: #62d98f; }
.engine-status[data-state="failed"]::before { background: #ff7b7b; }
@keyframes pulse { from { opacity: 0.35; } to { opacity: 1; } }

/* Main column */
main { max-width: 760px; margin: 0 auto; padding-inline: 16px; padding-block: 12px 64px; }
main h2 {
  font-weight: normal;
  color: var(--accent);
  font-size: 1.55rem;
  line-height: 1.3;
  margin: 2.2em 0 0.5em;
  text-wrap: balance;
}
main h3 { font-size: 1.15rem; line-height: 1.35; margin: 1.6em 0 0.4em; }
main p { margin: 0 0 1em; }
main ul, main ol { padding-left: 1.3em; margin: 0 0 1em; }
main li { margin-bottom: 0.35em; }
a { color: var(--accent); }
code {
  font-family: var(--mono);
  font-size: 0.86em;
  background: var(--tint);
  color: var(--code-ink);
  padding: 1px 5px;
  border-radius: 4px;
}
:focus-visible { outline: 3px solid var(--focus); outline-offset: 2px; }

main table {
  border-collapse: collapse;
  width: 100%;
  margin: 0 0 1.2em;
  font-family: var(--sans);
  font-size: 0.92rem;
  background: var(--paper);
  border: 1px solid var(--line);
  border-radius: 8px;
  overflow: hidden;
}
main th, main td {
  padding: 9px 14px;
  text-align: left;
  border-bottom: 1px solid var(--line);
}
main th { background: var(--tint); font-weight: bold; }
main tr:last-child td { border-bottom: none; }
main td code, main th code { white-space: nowrap; }
@media (max-width: 600px) {
  main table { display: block; overflow-x: auto; }
}

.goals {
  background: var(--paper);
  border: 1px solid var(--line);
  border-radius: 10px;
  padding: 18px 20px 8px;
  margin: 22px 0;
}
.goals h2 { margin: 0 0 6px; font-size: 1.1rem; font-family: var(--sans); font-weight: bold; color: var(--ink); }

.note {
  background: var(--tint);
  border-radius: 8px;
  padding: 14px 18px;
  margin: 18px 0;
  font-size: 0.96em;
}
.note p:last-child { margin-bottom: 0; }
.note-title { font-family: var(--sans); font-weight: bold; font-size: 13px; letter-spacing: 0.05em; text-transform: uppercase; color: var(--accent); display: block; margin-bottom: 4px; }

/* Breakdown of one line of code */
.anatomy { overflow-x: auto; margin: 16px 0 20px; }
.anatomy-line { display: flex; flex-wrap: wrap; gap: 10px 4px; font-family: var(--mono); font-size: 1.15rem; }
.anatomy-part { display: flex; flex-direction: column; align-items: center; gap: 6px; }
.anatomy-part code { font-size: 1.15rem; padding: 6px 8px; background: var(--code-bg); border: 1px solid var(--line); }
.anatomy-part span { font-family: var(--sans); font-size: 12.5px; color: var(--muted); text-align: center; max-width: 130px; line-height: 1.3; }

/* Code boxes */
.sqlbox {
  background: var(--paper);
  border: 1px solid var(--line);
  border-radius: 10px;
  margin: 16px 0 22px;
  overflow: hidden;
}
.jsbox-head {
  display: flex;
  justify-content: space-between;
  gap: 10px;
  padding: 7px 12px;
  font-family: var(--sans);
  font-size: 12px;
  color: var(--muted);
  border-bottom: 1px solid var(--line);
}
.jsbox-tag { font-weight: bold; letter-spacing: 0.06em; text-transform: uppercase; color: var(--accent); }
.sqlbox textarea {
  display: block;
  width: 100%;
  border: 0;
  margin: 0;
  resize: none;
  overflow: hidden;
  overflow-x: auto;
  white-space: pre;
  font-family: var(--mono);
  font-size: 15px;
  line-height: 1.6;
  padding: 12px 14px;
  background: var(--code-bg);
  color: var(--code-ink);
  tab-size: 4;
}
.sqlbox textarea:focus-visible { outline: 2px solid var(--focus); outline-offset: -2px; }
.jsbox-input { padding: 8px 12px; border-top: 1px dashed var(--line); font-family: var(--sans); font-size: 13px; color: var(--muted); }
.jsbox-input label { display: block; margin-bottom: 4px; }
.jsbox-input textarea { background: var(--paper); border: 1px solid var(--line); border-radius: 6px; padding: 6px 8px; font-size: 14px; }
.jsbox-bar { display: flex; flex-wrap: wrap; gap: 8px; padding: 10px 12px; border-top: 1px solid var(--line); }

.btn {
  font-family: var(--sans);
  font-size: 14px;
  font-weight: bold;
  border-radius: 7px;
  padding: 8px 16px;
  cursor: pointer;
  border: 1px solid transparent;
  line-height: 1.2;
}
.btn:disabled { opacity: 0.5; cursor: default; }
.btn-run { background: var(--vi-blue); color: #fff; }
.btn-run:hover:not(:disabled) { background: var(--vi-blue-dark); }
.btn-check { background: var(--vi-gold); color: var(--vi-blue-dark); }
.btn-check:hover:not(:disabled) { background: #ffca4a; }
.btn-quiet { background: transparent; color: var(--accent); border-color: var(--line); font-weight: normal; }
.btn-quiet:hover:not(:disabled) { background: var(--tint); }
.btn-small { font-size: 13px; padding: 5px 12px; background: var(--vi-blue); color: #fff; }

.jsbox-out { background: var(--out-bg); color: var(--out-ink); padding: 8px 14px 12px; }
.out-label { font-family: var(--sans); font-size: 11px; font-weight: bold; letter-spacing: 0.08em; text-transform: uppercase; opacity: 0.7; margin-bottom: 2px; }
.out-text { margin: 0; font-family: var(--mono); font-size: 14.5px; line-height: 1.55; white-space: pre; overflow-x: auto; }
.out-err { color: var(--out-err); }
.out-none, .out-wait { color: #a3abd6; font-style: italic; white-space: normal; }
.jsbox-out .explain {
  font-family: var(--sans);
  font-size: 14px;
  line-height: 1.5;
  background: rgba(255, 255, 255, 0.07);
  border-radius: 6px;
  padding: 8px 10px;
  margin: 10px 0 0;
}
.jsbox-out .explain .btn-small { margin-top: 6px; background: var(--vi-gold); color: var(--vi-blue-dark); }

/* Static output shown in the text */
.shows { margin: -10px 0 20px; }
.shows pre { background: var(--out-bg); color: var(--out-ink); font-family: var(--mono); font-size: 14.5px; padding: 10px 14px; border-radius: 0 0 10px 10px; margin: 0; overflow-x: auto; }

/* Mistakes list */
.mistake { border-top: 1px solid var(--line); padding-top: 6px; }

/* Exercises */
.exercise {
  background: var(--paper);
  border: 1px solid var(--line);
  border-radius: 12px;
  padding: 4px 18px 16px;
  margin: 26px 0;
}
.exercise h3 { font-family: var(--sans); font-size: 1rem; color: var(--accent); display: flex; flex-wrap: wrap; align-items: center; gap: 10px; }
.exercise .sqlbox { margin: 12px 0 10px; }
.expected-label { font-family: var(--sans); font-size: 12px; font-weight: bold; letter-spacing: 0.06em; text-transform: uppercase; color: var(--muted); margin: 0 0 4px; }
.expected { background: var(--code-bg); border: 1px dashed var(--line); border-radius: 8px; font-family: var(--mono); font-size: 14.5px; padding: 8px 12px; margin: 0 0 8px; white-space: pre; overflow-x: auto; }
.done-badge { font-size: 11px; letter-spacing: 0.06em; text-transform: uppercase; background: var(--good-bg); color: var(--good); padding: 2px 9px; border-radius: 10px; }
.done-badge::before { content: "✓ "; }

.feedback { border-radius: 8px; padding: 12px 14px; font-family: var(--sans); font-size: 15px; line-height: 1.5; margin-top: 4px; }
.feedback p { margin: 4px 0 0; }
.feedback.good { background: var(--good-bg); color: var(--good); }
.feedback.bad { background: var(--bad-bg); color: var(--ink); }
.feedback.bad .fb-title { color: var(--bad); }
.feedback.pending { background: var(--tint); }
.fb-title { display: block; }
.compare { display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 10px; margin-top: 10px; }
.compare-col { background: var(--out-bg); color: var(--out-ink); border-radius: 8px; padding: 8px 12px; min-width: 0; }
.diff-line { background: var(--diff); outline: 1px solid rgba(255, 213, 128, 0.6); }

.solution-box { margin-top: 10px; border: 1px solid var(--line); border-radius: 8px; padding: 10px 12px; background: var(--code-bg); font-family: var(--sans); font-size: 14px; }
.sol-code { font-family: var(--mono); font-size: 14.5px; margin: 4px 0 8px; overflow-x: auto; color: var(--code-ink); }
.sol-note { margin: 0 0 8px; }

/* Quiz */
.quiz { margin: 18px 0; }
.quiz-q { background: var(--paper); border: 1px solid var(--line); border-radius: 10px; padding: 14px 18px; margin-bottom: 14px; }
.quiz-q > p { margin-bottom: 8px; }
.quiz-q ol { list-style: none; padding: 0; margin: 0; display: grid; gap: 8px; }
.opt {
  width: 100%;
  text-align: left;
  font-family: var(--sans);
  font-size: 15px;
  background: var(--code-bg);
  color: var(--ink);
  border: 1px solid var(--line);
  border-radius: 8px;
  padding: 9px 12px;
  cursor: pointer;
}
.opt code { background: transparent; padding: 0; }
.opt:hover:not([aria-disabled="true"]) { border-color: var(--accent); }
.opt[aria-disabled="true"] { cursor: default; }
.opt.is-right { background: var(--good-bg); border-color: var(--good); color: var(--good); }
.opt.is-wrong { background: var(--bad-bg); border-color: var(--bad); color: var(--bad); }
.why { font-family: var(--sans); font-size: 14.5px; line-height: 1.5; margin: 10px 0 0; }
.opt-mark { font-weight: bold; }
.sr-only { position: absolute; width: 1px; height: 1px; padding: 0; margin: -1px; overflow: hidden; clip: rect(0 0 0 0); white-space: nowrap; border: 0; }
.why:focus { outline: none; }
.quiz-score { font-family: var(--sans); font-weight: bold; color: var(--accent); }

/* Summary and footer */
.summary { background: var(--paper); border: 1px solid var(--line); border-radius: 12px; padding: 6px 20px 10px; margin-top: 30px; }
.course-complete { background: var(--vi-blue); color: #fff; border-radius: 12px; padding: 22px 24px 26px; margin-top: 30px; }
.course-complete h2 { color: #fff; margin-top: 0; }
.course-complete p { font-family: var(--sans); font-size: 15.5px; line-height: 1.6; }
.course-complete p:last-child { margin-bottom: 0; }

/* Buy/enroll promo banner — shown on the free preview lessons (1.1, 1.2) */
.course-promo {
  background: var(--paper);
  border: 2px solid var(--vi-blue);
  border-radius: 12px;
  padding: 18px 22px 20px;
  margin-top: 30px;
  display: flex;
  justify-content: space-between;
  align-items: center;
  flex-wrap: wrap;
  gap: 16px;
}
.course-promo-text h2 { margin: 0 0 6px; font-size: 1.15rem; color: var(--vi-blue); }
.course-promo-text p { font-family: var(--sans); font-size: 14.5px; line-height: 1.55; color: var(--ink); margin: 0; max-width: 46em; }
.btn-buy {
  font-family: var(--sans);
  font-size: 14.5px;
  font-weight: bold;
  border-radius: 8px;
  padding: 11px 20px;
  background: var(--vi-gold);
  color: var(--vi-blue-dark);
  text-decoration: none;
  white-space: nowrap;
  flex: 0 0 auto;
}
.btn-buy:hover { background: #ffca4a; }
@media (max-width: 600px) {
  .course-promo { flex-direction: column; align-items: stretch; text-align: center; }
  .btn-buy { text-align: center; }
}
.lesson-nav { display: flex; justify-content: space-between; gap: 12px; flex-wrap: wrap; margin-top: 30px; font-family: var(--sans); font-size: 15px; }
.lesson-nav a, .lesson-nav span { padding: 10px 16px; border-radius: 8px; border: 1px solid var(--line); background: var(--paper); text-decoration: none; }
.lesson-nav .next { background: var(--vi-blue); color: #fff; border-color: var(--vi-blue); }
.lesson-nav .soon { color: var(--muted); }
.lesson-nav .course-done { background: var(--good-bg); color: var(--good); border-color: var(--good); font-weight: 600; }
.report { font-family: var(--sans); font-size: 13.5px; color: var(--muted); margin-top: 26px; }
footer { text-align: center; font-family: var(--sans); font-size: 13px; color: var(--muted); padding: 24px 16px 40px; border-top: 1px solid var(--line); }

@media (max-width: 600px) {
  body { font-size: 17px; }
  .top-bar { padding-inline: 14px; }
  .top-bar-logo img { height: 36px; }
  .top-bar-nav { gap: 14px; font-size: 13px; }
  .exercise { padding-inline: 12px; }
  .sqlbox textarea, .jsbox-input textarea { font-size: 16px; }
}
@media (prefers-reduced-motion: reduce) {
  .prog-fill { transition: none; }
  .engine-status[data-state="loading"]::before { animation: none; }
}

/* Ordered instruction lists (Lesson 1.1) */
.order-safe, .order-unsafe {
  font-family: var(--mono);
  font-size: 1.05rem;
  background: var(--code-bg);
  border-radius: 8px;
  padding: 14px 16px 14px 40px;
  margin: 14px 0 20px;
}
.order-safe { border-left: 4px solid var(--good); }
.order-unsafe { border-left: 4px solid var(--bad); }
.order-safe li, .order-unsafe li { margin-bottom: 6px; }

/* ---- JavaScript course additions ---- */
/* The hidden sealed-off frame each Run uses when there is no practice page */
.jsbox-hidden-frame { position: absolute; width: 0; height: 0; border: 0; visibility: hidden; }
/* The practice web page shown in Module 12 onwards */
.jsbox-page { border-top: 1px solid var(--line); padding: 8px 12px 12px; background: var(--tint); }
.jsbox-page .out-label { color: var(--muted); opacity: 1; margin-bottom: 6px; }
.jsbox-frame { display: block; width: 100%; height: 120px; border: 1px solid var(--line); border-radius: 8px; background: #fff; }
.out-warn { color: var(--vi-gold); }
.out-errlog { color: var(--out-err); }
/* Source code of a practice page, shown in the lesson text */
.page-src { margin: -10px 0 20px; }
.page-src pre { background: var(--code-bg); border: 1px solid var(--line); border-radius: 0 0 10px 10px; font-family: var(--mono); font-size: 14px; padding: 10px 14px; margin: 0; overflow-x: auto; color: var(--code-ink); }
/* The practice page's HTML, shown above the code in Module 12 onwards */
.page-html { border-bottom: 1px solid var(--line); font-family: var(--sans); font-size: 13px; }
.page-html summary { cursor: pointer; padding: 7px 12px; color: var(--accent); }
.page-html pre { margin: 0; padding: 8px 14px 12px; font-family: var(--mono); font-size: 13.5px; line-height: 1.5; overflow-x: auto; background: var(--paper); color: var(--code-ink); }
/* Long inline code (e.g. document.querySelector("#message")) may break
   onto the next line on a narrow phone instead of widening the page. */
main p code, main li code, .why code, .note code, .opt code { overflow-wrap: anywhere; }

/* ---------- SQL course: result tables ---------- */
.result { margin: 6px 0 10px; }
.table-wrap { overflow: auto; max-height: 440px; max-width: 100%; border-radius: 6px; }
main .result-table { display: table; width: auto; min-width: 50%; margin: 0; border: 0; border-radius: 0; overflow: visible; background: transparent; border-collapse: collapse; font-family: var(--mono); font-size: 14px; line-height: 1.45; color: inherit; }
main .result-table th, main .result-table td { padding: 4px 14px; text-align: left; vertical-align: top; white-space: pre; background: transparent; border-bottom: 1px solid rgba(128, 140, 200, 0.28); }
main .result-table th { position: sticky; top: 0; font-weight: 600; background: #26306a; color: #fff; border-bottom: 0; }
main .result-table td.num { text-align: right; }
main .result-table td.null { color: #9aa3cf; font-style: italic; }
main .result-table tbody tr:nth-child(even) td { background: rgba(128, 140, 200, 0.12); }
main .result-table tr:last-child td { border-bottom: 1px solid rgba(128, 140, 200, 0.28); }
main .result-table tbody tr.diff-row td { background: rgba(255, 196, 77, 0.45); color: #fff; }
.row-count { font-family: var(--sans); font-size: 12.5px; opacity: 0.75; margin: 4px 0 0; }
.result-label { font-family: var(--sans); font-size: 12px; font-weight: bold; margin: 10px 0 2px; opacity: 0.85; }
.out-done { margin: 4px 0; font-family: var(--mono); font-size: 14px; color: #a8e6bd; }
.jsbox-out p.out-err { margin: 6px 0 0; font-family: var(--mono); font-size: 14.5px; white-space: pre-wrap; }
.jsbox-out p.out-none, .jsbox-out p.explain { margin: 6px 0 0; }
.expected.expected-table { white-space: normal; font-family: var(--sans); color: var(--ink); }
main .expected-table .result-table td.null { color: var(--muted); }
main .expected-table .result-table tbody tr:nth-child(even) td { background: var(--tint); }
.expected-table .row-count { color: var(--muted); }
.expected-table .out-none { color: var(--muted); }
.expected-table .out-err { color: var(--bad); }
.check-note { font-family: var(--sans); font-size: 14px; color: var(--muted); margin: 0 0 6px; }
.check-note code { white-space: normal; }

/* Tables-in-this-database panel */
.db-tables { border-bottom: 1px solid var(--line); background: var(--tint); font-family: var(--sans); font-size: 13.5px; }
.db-tables summary { cursor: pointer; padding: 6px 12px; color: var(--accent); font-weight: bold; }
.db-tables-body { padding: 0 12px 8px; }
.db-table { margin: 4px 0; line-height: 1.6; }
.db-table code { font-size: 13px; }
.db-table code.pk { text-decoration: underline; text-underline-offset: 3px; }
.col-type { color: var(--muted); font-size: 12px; }
.db-note { color: var(--muted); font-size: 12.5px; margin: 6px 0 0; }

/* Static tables of data shown in the lesson text */
main .data-table { width: auto; font-family: var(--mono); font-size: 14px; }
main .data-table th { font-family: var(--sans); }
.data-table-wrap { overflow-x: auto; }