Skip to main content
SimilarExport ZIP
100%

SQL query from hell - original from our source

✓ Published0🌍 Public
HHoffmannP
Last edited Dec 2, 2015
Created on Dec 2, 2015

This example visualizes the results of a complex SQL query that retrieves school contact data, including a computed responsible person, formatted timestamps, and concatenated school names. The query processes relational data from multiple tables, using `IFNULL`, `IF`, and `DATE_FORMAT` for field transformations, and a correlated subquery to filter for the most recent follow-up contact. Rendering is not shown in the code, but the output appears structured for direct chart consumption, likely using a client-side library like D3 or a table-based UI. The visualization relies on the query’s ordered rows and grouped fields to display chronological contact activity.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 5567358

This visualization demonstrates how SQL handles null values in comparison and assignment operations. It shows the distinct results of various null-checking predicates—including `<=>`, `IS NULL`, `IS NOT NULL`, and `ISNULL`—combined with `IF` logic and the `IFNULL` function. The query executes against a single-row dataset containing the value `1`, then uses `GROUP BY ... WITH ROLLUP` to produce aggregated output, highlighting differences between MySQL’s null-safe equality operator and standard null checks. The gallery example relies on standard SQL execution, with no additional charting or graphics libraries involved.

HHoffmannP
57% match
Loading thumbnail…

just a bookmark of random psql queries.

This example visualizes spatial relationships between neighborhoods, city blocks, and demographic data in Portland and Laurelhurst through a series of SQL queries. The code shows how geographic joins and intersections are performed using PostGIS functions like `ST_Intersects`, combining building footprints, block polygons, and census block-group data. The queries calculate race-based percentages, such as percent white and percent black, from census fields like `h7x002` and `h7x003`, while filtering for specific places and positive population counts. The gist demonstrates iterative query building for choropleth-style analysis, revealing how raw geographic and tabular data are merged to support subsequent mapping or charting in a visualization tool.

CCaged
57% match
Loading thumbnail…

Steve Baskauf's SPARQL query for ORCIDs at Vanderbilt

This visualization identifies people who are both students and employees at Vanderbilt by querying ORCID data with SPARQL, then displays their names and works as a network. It shows the overlapping creators between the two groups before revealing individual contributors. The code uses a SPARQL query with `MINUS` clauses to filter statuses and `ORDER BY` family name, running against a Vanderbilt ORCID graph. The rendering relies on standard SPARQL result processing, with no external visualization library specified; the output is a simple tabular or list-based view of the matched names and works.

CCliffordAnderson
56% match
Loading thumbnail…

Functional SQL: https://www.codewars.com/kata/545434090294935e7d0010ab

This example recreates a functional SQL query engine in JavaScript, translating a Codewars kata into a working API. The code defines a `query` object with chainable methods like `select`, `from`, `where`, `groupBy`, `having`, and `orderBy`, mirroring SQL clause semantics. It performs cross joins across multiple arrays, applies filtering via nested callback arrays, and builds nested group structures using plain objects and recursive traversal. The final `execute` method returns mapped rows, demonstrating how relational query concepts can be implemented without external libraries, relying solely on native array methods and object literals.

MMunishkin
55% match
Loading thumbnail…

Graph Gist

This example shows a small graph of people and their database preferences, capturing two `Person` nodes connected by `LIKE` relationships to database nodes labeled `Database`, `NoSql`, and `Graph`. The visualization renders this graph data using D3.js, likely with a force-directed layout (`d3.forceSimulation`) to position nodes and links, and possibly `d3.geoPath` or standard SVG/CSS for shapes and labels. The source code, authored by CliffordAnderson and stored as a Gist, explicitly creates the nodes and relationships with Cypher, returning them for immediate display. The result emphasizes how graph structures and their labels can be directly mapped from query output to interactive visual elements.

CCliffordAnderson
54% match
Loading thumbnail…

Gist 8bb4970e2700b40a3dce1d785654d907

This visualization uses a force-directed graph to map the relationships between identifiers extracted from a Power Query M codebase. The data originates from a gist by Hugoberry, showing dependencies among functions, modules, and error-handling patterns. The rendering relies on D3.js’s `forceSimulation` with custom link and node positioning, while each node’s label is drawn using SVG text. The code specifically highlights groupings like `TableAction.*`, `ValueAction.*`, and `Pattern.*`, revealing hierarchical clusters of related API calls. The graph’s layout is animated via D3’s tick handler, and the visible node sizes suggest a metric like degree centrality, though the exact encoding is not explicit in the snippet.

HHugoberry
54% match
Loading thumbnail…

Fork of ICE6.1

This visualization displays student data from Hogwarts, mapping roll numbers against hobby categories as colored dots. It uses D3 v6 to load a CSV file, scales the data linearly, and renders circles colored by house (Gryffindor, Hufflepuff, Slytherin, Ravenclaw) via an SVG. The code uses `d3.csv`, `scaleLinear`, `extent`, and axis functions (`axisLeft`, `axisBottom`) to create the scatterplot. Labels for "Petal Length" and "Sepal Length" are added, though the data fields are roll number and hobby.

Vvedasrivarma13@gmail.com
54% match
Loading thumbnail…

Gist 652595e55960a8e04a29

This example visualizes the spatial relationships between metropolitan statistical areas and their constituent counties, townships, and other administrative geometries. The code first builds a combined geometry table using SQL, merging overlapping regions across multiple spatial layers while excluding special cases like Boston. It then renders these shapes using D3.js, likely leveraging `d3.geoPath` for projection and canvas or SVG drawing. The query explicitly handles hierarchical and overlapping geographies, prioritizing township-level detail where available and falling back to county unions for other areas. The final visualization shows how different government boundaries interlock within U.S. metropolitan regions, with the SQL preprocessing ensuring no duplicated or missing polygons.

CCaged
53% match