/* Pages de cours statiques de SQL Quest : même charte que l'application */
:root{--bg:#f4f5f7;--card:#fff;--soft:#f5f5f5;--line:#e5e5e5;--line2:#ddd;--tx:#333;--mu:#777;--dark:#333;--dark2:#292929;
  --green:#45be84;--green2:#3aa572;--blue:#096E9B;--red:#ca044b;--orange:#f0ad4e;--shadow:0 0 11px -8px rgba(0,0,0,.9);color-scheme:light}
*{box-sizing:border-box}
html{scroll-behavior:smooth;scroll-padding-top:16px}
body{margin:0;background:var(--bg);color:#444;font:16.5px/1.75 Montserrat,system-ui,sans-serif}
a{color:var(--blue)}
h1,h2,h3{color:var(--tx);line-height:1.25}
code{font-family:"JetBrains Mono",Consolas,monospace;font-size:.86em;background:#f9f2f4;color:var(--red);padding:2px 6px;border-radius:4px}
[hidden]{display:none!important}

/* En-tête ondulé */
header.top{position:relative;z-index:30;display:flex;align-items:center;gap:22px;padding:14px 28px 10px;background:var(--dark);color:#fff;margin-bottom:46px}
header.top::after{content:"";position:absolute;left:0;right:0;top:100%;height:44px;pointer-events:none;
  background:url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 1200 44' preserveAspectRatio='none'%3E%3Cpath d='M0 0H1200V30C960 46 820 14 600 26S220 42 0 22Z' fill='%23292929'/%3E%3Cpath d='M0 0H1200V18C980 36 800 4 580 16S200 34 0 12Z' fill='%23333333'/%3E%3C/svg%3E") no-repeat;background-size:100% 100%}
.brand{display:flex;align-items:center;gap:10px;color:#fff;text-decoration:none;font-weight:700;font-size:20px;white-space:nowrap}
.logo{display:grid;place-items:center;width:40px;height:40px;border-radius:10px;background:linear-gradient(to top,var(--green2),var(--green));color:#fff;font-size:18px;box-shadow:0 3px 10px -3px rgba(69,190,132,.8)}
.nav{display:flex;gap:2px;overflow-x:auto;margin-left:auto;scrollbar-width:none}.nav::-webkit-scrollbar{display:none}
.nav a{position:relative;color:#fff;text-decoration:none;font-weight:700;font-size:13px;text-transform:uppercase;letter-spacing:.5px;padding:9px 11px;white-space:nowrap;opacity:.75;transition:.15s}
.nav a i{margin-right:6px}.nav a:hover,.nav a.on{opacity:1}.nav a.on::after{content:"";position:absolute;left:11px;right:11px;bottom:2px;height:3px;border-radius:3px;background:var(--green)}
.stats{display:flex;gap:8px;align-items:center}.chip{display:flex;align-items:center;gap:7px;background:rgba(255,255,255,.08);border:1px solid rgba(255,255,255,.14);padding:5px 12px;border-radius:999px;font-weight:700;font-size:13px;white-space:nowrap;color:#fff;text-decoration:none}.chip.acct{border-color:rgba(69,190,132,.5)}.chip.acct i{color:var(--green)}.chip .fa-star{color:#f7d154}.chip .fa-trophy{color:var(--green)}

/* Mise en page */
.page{max-width:1180px;margin:0 auto;padding:0 24px 40px}
.crumbs{font-size:13.5px;color:var(--mu);margin:0 0 18px} .crumbs a{color:var(--mu)} .crumbs span{color:var(--tx);font-weight:600}
.layout{display:grid;grid-template-columns:230px 1fr;gap:28px;align-items:start}
.toc{position:sticky;top:16px;background:#fff;border:1px solid var(--line);border-radius:12px;padding:14px;box-shadow:var(--shadow);font-size:14px}
.toch{font-size:11px;text-transform:uppercase;letter-spacing:.08em;color:var(--mu);font-weight:700;margin-bottom:6px}
.toc a{display:block;padding:6px 8px;border-radius:6px;text-decoration:none;color:var(--tx);font-weight:500}
.toc a:hover{background:var(--soft)}
.toc .tocapp{margin-top:8px;border-top:1px solid var(--line);padding-top:10px;color:var(--green2);font-weight:700}
article{background:#fff;border:1px solid var(--line);border-radius:14px;padding:30px 40px;box-shadow:var(--shadow);min-width:0}
.ahead{border-bottom:1px solid var(--line);padding-bottom:16px;margin-bottom:8px}
.ahead h1{font-size:36px;margin:8px 0 10px}
.meta{color:var(--mu);font-size:13.5px;margin:0} .meta i{color:var(--green2);margin:0 2px 0 6px} .meta i:first-child{margin-left:0}
.lvl{display:inline-block;font-size:11px;font-weight:700;text-transform:uppercase;letter-spacing:.06em;padding:3px 10px;border-radius:4px;background:#d9edf7;color:var(--blue)}
section{padding-top:6px}
section h2{font-size:25px;margin:30px 0 12px;padding-top:18px;border-top:1px solid var(--line)}
#intro{font-size:17.5px}
h3{font-size:18.5px;margin:22px 0 8px}
table.ref{border-collapse:collapse;width:100%;font-size:15px;margin:10px 0 16px}
table.ref th,table.ref td{border:1px solid var(--line);padding:8px 12px;text-align:left;vertical-align:top}
table.ref th{background:var(--soft);color:var(--tx)}
.note{font-size:14px;color:var(--mu)}
.chip.lang:hover{border-color:var(--green)}
/* Glossaire des pages anglaises (la base d'exemple garde ses noms français) */
.gloss{border:1px solid var(--line);border-radius:10px;background:var(--soft);margin:14px 0 0;font-size:14px}
.gloss summary{cursor:pointer;padding:10px 14px;font-weight:700}.gloss summary i{color:var(--green2);margin-right:6px}
.gloss dl{display:grid;grid-template-columns:repeat(auto-fill,minmax(230px,1fr));gap:6px 18px;margin:0;padding:4px 14px 14px}
.gloss dl div{display:flex;gap:8px;align-items:baseline}.gloss dt{margin:0;flex:none}.gloss dd{margin:0;color:var(--mu)}

/* Code */
pre.sql{background:#272822;color:#f8f8f2;border-radius:8px;padding:14px 16px;overflow:auto;font:14px/1.6 "JetBrains Mono",Consolas,monospace;margin:12px 0}
pre.sql code{background:none;color:inherit;padding:0;font-size:inherit}

/* Exemples et résultats */
.example{border:1px solid var(--line);border-radius:12px;padding:4px 20px 16px;margin:16px 0;background:#fcfcfd}
.try{display:inline-flex;align-items:center;gap:7px;font-size:13px;font-weight:700;text-decoration:none;color:#fff;background:linear-gradient(to top,var(--green2),var(--green));padding:7px 13px;border-radius:4px;text-transform:uppercase;letter-spacing:.4px}
.try:hover{filter:brightness(.95)}
.result{margin-top:12px} .rlabel{font-size:11px;font-weight:700;text-transform:uppercase;letter-spacing:.08em;color:var(--mu);margin-bottom:6px}
.tbl{overflow:auto;border:1px solid var(--line);border-radius:6px}
.tbl table{border-collapse:collapse;width:max-content;min-width:100%;font:13px "JetBrains Mono",Consolas,monospace}
.tbl th{background:var(--dark);color:#fff;font:600 12px Montserrat,sans-serif;text-transform:uppercase;letter-spacing:.4px;text-align:left;padding:7px 12px}
.tbl td{padding:6px 12px;border-bottom:1px solid #eee;color:var(--tx)} .tbl tbody tr:nth-child(even) td{background:#fafafa}
.tbl td.num{color:var(--blue);text-align:right} .tbl td.nul,.mt td.nul{color:#b5b8bf;font-style:italic}
.rcount{font-size:12.5px;color:var(--mu);margin:6px 0 0} .noresult{color:var(--mu);font-style:italic}

/* Schéma */
.schema{margin:14px 0 6px;background:var(--soft);border:1px solid var(--line);border-radius:12px;padding:18px}
.flow{display:flex;align-items:center;gap:16px;flex-wrap:wrap;justify-content:center}
.arrow{font-size:30px;color:var(--green2);font-weight:700}
.mt{background:#fff;border:1px solid var(--line2);border-radius:8px;overflow:hidden;box-shadow:var(--shadow)}
.mt.out{border-color:var(--green)}
.mtn{font:700 12px "JetBrains Mono",monospace;background:var(--dark);color:#fff;padding:5px 10px}
.mt.out .mtn{background:var(--green2)}
.mt table{border-collapse:collapse;font:13px "JetBrains Mono",monospace}
.mt th{font-weight:600;color:var(--mu);font-size:11.5px;text-align:left;padding:5px 10px;border-bottom:1px solid var(--line)}
.mt td{padding:5px 10px;border-bottom:1px solid #f0f0f0;color:var(--tx)}
.mt tr.keep td{background:#e9f7ef} .mt tr.drop td{opacity:.4;text-decoration:line-through} .mt tr.null td{background:#fff6e5}
.mt tr.g1 td{background:#e9f7ef} .mt tr.g2 td{background:#e6f1f8}
.mt th.keep,.mt td.keep{background:#e9f7ef} .mt th.new,.mt td.new{background:#fff6e5;font-weight:600}
.schema figcaption{text-align:center;font-size:14px;color:var(--mu);margin-top:12px}

/* Erreurs */
.error{margin:18px 0} .error h3 i{color:var(--orange)}
.cmp{display:grid;grid-template-columns:1fr 1fr;gap:12px}
.cmp>div{min-width:0} .cmp span{display:inline-block;font-size:11px;font-weight:700;text-transform:uppercase;letter-spacing:.06em;padding:2px 8px;border-radius:4px}
.bad span{background:#f2dede;color:#a94442} .good span{background:#dff0d8;color:#3c763d}
.bad pre.sql{box-shadow:inset 4px 0 0 #d9534f} .good pre.sql{box-shadow:inset 4px 0 0 var(--green)}

/* Exercices et FAQ */
.challenge{border-left:4px solid var(--blue);background:#f6fafc;border-radius:0 10px 10px 0;padding:6px 18px 12px;margin:14px 0}
details summary{cursor:pointer;font-weight:700;color:var(--blue)}
.cta{display:flex;align-items:center;gap:18px;flex-wrap:wrap;background:var(--dark);color:#ccc;border-radius:12px;padding:18px 22px;margin:22px 0 0}
.cta b{color:#fff} .cta p{margin:4px 0 0;font-size:14.5px} .cta>div{flex:1;min-width:240px}
.btn{display:inline-flex;align-items:center;gap:8px;text-decoration:none;color:#fff;background:linear-gradient(to top,var(--green2),var(--green));padding:11px 18px;border-radius:4px;font-weight:700;font-size:13.5px;text-transform:uppercase;letter-spacing:.4px}
.btn.light{background:#fff;color:var(--tx);border:1px solid var(--line2)}
.faqi{border:1px solid var(--line);border-radius:10px;padding:12px 16px;margin:10px 0;background:#fcfcfd}
.faqi summary{color:var(--tx)} .faqi p{margin:8px 0 0}

/* Suite */
.rels{display:grid;grid-template-columns:repeat(3,1fr);gap:12px}
.rel{display:block;border:1px solid var(--line);border-radius:10px;padding:14px;text-decoration:none;color:var(--tx);background:#fcfcfd}
.rel:hover{border-color:var(--green)} .rel b{display:block;margin:6px 0 4px;font-size:15px;line-height:1.35} .rel small{color:var(--mu);font-size:13px;line-height:1.5}
.pn{display:flex;justify-content:space-between;gap:12px;margin-top:18px}
.pn a{flex:1;max-width:48%;border:1px solid var(--line);border-radius:10px;padding:12px 16px;text-decoration:none;color:var(--tx);font-weight:700}
.pn a small{display:block;color:var(--mu);font-size:11px;text-transform:uppercase;letter-spacing:.06em} .pn a.n{text-align:right;margin-left:auto}

/* Index des cours */
.hubhead{background:#fff;border:1px solid var(--line);border-radius:14px;padding:30px 36px;box-shadow:var(--shadow)}
.hubhead h1{font-size:36px;margin:0 0 10px} .hubhead p{font-size:17px;margin:0}
.hubcta{display:flex;gap:10px;flex-wrap:wrap;margin-top:20px}
.lvlsec h2{display:flex;align-items:center;gap:12px;font-size:23px;margin:34px 0 14px}
.cards{display:grid;grid-template-columns:repeat(3,1fr);gap:14px}
.card{position:relative;display:block;background:#fff;border:1px solid var(--line);border-radius:12px;padding:18px 18px 16px 58px;text-decoration:none;color:var(--tx);box-shadow:var(--shadow)}
.card:hover{border-color:var(--green)}
.card .n{position:absolute;left:16px;top:18px;width:30px;height:30px;border-radius:50%;background:var(--green);color:#fff;font-weight:700;display:grid;place-items:center;font-size:14px}
.card b{display:block;font-size:15.5px;line-height:1.35;margin-bottom:6px} .card small{color:var(--mu);font-size:13px;line-height:1.5}
.howto{background:#fff;border:1px solid var(--line);border-radius:14px;padding:6px 30px 18px;margin-top:34px;box-shadow:var(--shadow)}

/* Publicité */
.adzone{margin:30px 0;text-align:center;overflow:hidden}
.adlabel{font-size:10.5px;text-transform:uppercase;letter-spacing:.1em;color:#aaa;margin-bottom:8px}

/* Pied de page */
.foot{position:relative;margin-top:70px;background:var(--dark2);color:#bbb;text-align:center;padding:24px 20px 28px;font-size:14px}
.foot::before{content:"";position:absolute;left:0;right:0;bottom:100%;height:56px;pointer-events:none;
  background:url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 1200 56' preserveAspectRatio='none'%3E%3Cpath d='M0 30C240 6 420 44 640 26S1000 0 1200 20V56H0Z' fill='%231e472c'/%3E%3Cpath d='M0 40C260 20 460 54 700 38S1020 18 1200 34V56H0Z' fill='%23333333'/%3E%3Cpath d='M0 50C300 36 520 60 760 48S1060 38 1200 46V56H0Z' fill='%23292929'/%3E%3C/svg%3E") no-repeat;background-size:100% 100%}
.fnav{display:flex;gap:18px;justify-content:center;flex-wrap:wrap;margin-bottom:8px} .fnav a{color:#ddd}
.foot b{color:#fff} .foot .fa-heart{color:#ff6b93} .foot p{margin:0}

@media(max-width:1440px){header.top{flex-wrap:wrap;row-gap:6px}.nav{order:3;width:100%;margin-left:0}.stats{margin-left:auto}}
@media(max-width:980px){
  .layout{grid-template-columns:1fr} .toc{position:static;display:flex;flex-wrap:wrap;gap:4px} .toc .toch{width:100%}
  .rels,.cards{grid-template-columns:1fr 1fr}
}
@media(max-width:680px){
  body{font-size:15.5px} header.top{padding:12px 16px 6px;gap:10px}.brand{font-size:18px}.stats .chip:not(.acct):not(.lang){display:none}.nav a{padding:6px 8px;font-size:12px}
  .page{padding:0 14px 30px} article,.hubhead{padding:20px 18px} .ahead h1,.hubhead h1{font-size:27px} section h2{font-size:21px}
  .cmp,.rels,.cards{grid-template-columns:1fr} .example{padding:2px 14px 14px} .pn a{max-width:none}
}

/* Aide-mémoire */
.order{display:flex;flex-wrap:wrap;gap:6px;align-items:center;margin:8px 0 14px}
.order span{background:var(--dark);color:#fff;font:600 13px "JetBrains Mono",monospace;padding:6px 10px;border-radius:5px}
.order i{color:var(--mu);font-style:normal;font-weight:700}
.mgrid{display:grid;grid-template-columns:repeat(2,1fr);gap:14px}
.mcard{border:1px solid var(--line);border-radius:10px;padding:4px 16px 14px;background:#fcfcfd;min-width:0}
.mcard h3{font-size:16px;margin:12px 0 4px} .mcard a{font-size:14px;font-weight:600}
.toc a i{width:16px;margin-right:4px}
@media(max-width:680px){.mgrid{grid-template-columns:1fr}}