neilernst

--==============================
-- Send Keynote Text to Desktop Markdown File
-- Formats the markdown as Marp syntax (a MarkDown presentation format) https://marp.app
-- Based on 
-- Writted By: Richard Dooling https://github.com/RichardDooling/
-- Based on 
-- Send Keynote Presenter Notes to Evernote
-- Version 1.0.1
-- Written By: Ben Waldie <ben@automatedworkflows.com>
-- http://www.automatedworkflows.com

neilernst

SELECT
  cont.sample_repo_name,
  repo.watch_count
FROM
  [bigquery-public-data:github_repos.sample_contents] as cont
JOIN [bigquery-public-data:github_repos.sample_repos] as repo
  ON cont.sample_repo_name = repo.repo_name
WHERE
  cont.content CONTAINS 'spring-boot-starter-security</artifactId>'
  AND cont.sample_path LIKE 'pom.xml'