René's URL Explorer Experiment

{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://sqlint.com/#organization","name":"SqlInt","url":"https://sqlint.com","logo":"https://sqlint.com/og-image.jpg","email":"support.sqlint@gmail.com","description":"SqlInt is a browser-based SQL practice and interview-preparation platform that also provides free client-side SQL tools for developers.","disambiguatingDescription":"SqlInt (sqlint.com) is a browser-based SQL practice and interview-preparation website with free client-side SQL tools - a web platform, not a command-line utility.","contactPoint":{"@type":"ContactPoint","contactType":"customer support","email":"support.sqlint@gmail.com","availableLanguage":["en"]},"subjectOf":[{"@type":"WebPage","url":"https://sqlint.com/about","name":"About SqlInt"}],"sameAs":[]},{"@type":"WebSite","@id":"https://sqlint.com/#website","url":"https://sqlint.com","name":"SqlInt","description":"SqlInt is a browser-based SQL practice and interview-preparation platform that also provides free client-side SQL tools for developers.","publisher":{"@id":"https://sqlint.com/#organization"}}]}

{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://sqlint.com"},{"@type":"ListItem","position":2,"name":"Learn SQL","item":"https://sqlint.com/learn-sql"},{"@type":"ListItem","position":3,"name":"CASE WHEN","item":"https://sqlint.com/learn-sql/case-when"}]}

{"@context":"https://schema.org","@type":"FAQPage","mainEntity":[{"@type":"Question","name":"Why did my COUNT(CASE WHEN...THEN 1 ELSE 0 END) count every row?","acceptedAnswer":{"@type":"Answer","text":"Because ELSE 0 makes every row non-NULL, and COUNT counts non-NULL values — the zeros are counted too. Drop the ELSE so mismatches become NULL (skipped by COUNT), or use SUM with ELSE 0."}},{"@type":"Question","name":"Can CASE appear in WHERE, GROUP BY, or ORDER BY?","acceptedAnswer":{"@type":"Answer","text":"Everywhere — it is an expression, legal wherever expressions are. ORDER BY CASE is the idiomatic custom sort; GROUP BY CASE can bucket rows before aggregation; in WHERE it works but plain OR logic is often clearer."}}]}

{"@context":"https://schema.org","@type":"LearningResource","@id":"https://sqlint.com/learn-sql/case-when#learning-resource","name":"CASE WHEN — SQL Tutorial with Examples","description":"Learn SQL CASE WHEN. Includes syntax, examples, mistakes, and interview tips.","speakable":{"@type":"SpeakableSpecification","cssSelector":["h1",".topic-explanation"]},"citation":["https://www.postgresql.org/docs/current/sql.html","https://sqlite.org/lang.html","https://www.postgresql.org/docs/current/tutorial.html"],"isPartOf":{"@id":"https://sqlint.com/learn-sql#course"},"educationalLevel":"Intermediate","teaches":["Syntax: CASE\n  WHEN condition1 THEN result1\n  WHEN condition2 THEN result2\n  ELSE default_result\nEND","Core concept: CASE WHEN adds conditional logic inside SQL — like if/else statements. It can be used in SELECT, WHE","Common mistakes: Forgetting the END keyword. Also: CASE evaluates conditions top-to-bottom and returns on the first T","Interview tips: The SUM(CASE WHEN...) pattern is essential for pivoting data — turning rows into columns. Interviewe"],"timeRequired":"12 mins","about":{"@type":"Thing","name":"SQL","description":"Structured Query Language"},"audience":{"@type":"EducationalAudience","educationalRole":"student"},"author":{"@type":"Organization","@id":"https://sqlint.com/#organization","name":"SqlInt"},"url":"https://sqlint.com/learn-sql/case-when"}