This queries a shared DuckDB database on MotherDuck with StackOverflow Survey

query-stackoverflow-survey-motherduck.sql

--connect to MotherDuck databases
-- configure MOTHERDUCK_TOKEN and run DuckDB that connects to all shared Databases with
-- `duckdb "md:"`
-- and then run this query:
WITH language_counts AS (
      SELECT
          language,
          COUNT(*) AS count
      FROM (
          SELECT UNNEST(STRING_SPLIT(LanguageHaveWorkedWith, ';')) AS language
          FROM sample_data.stackoverflow_survey.survey_results
          WHERE year='2024'
      ) AS languages
      GROUP BY language
  ),
  max_count AS (
      SELECT MAX(count) as max_value
      FROM language_counts
  )
  SELECT
      language,
      count,
      bar(count, 0, max_count.max_value, 40) as chart
  FROM language_counts, max_count
  ORDER BY count DESC
  LIMIT 10;