Database |> Language |> 

Examples

Contents

The below are example SQL statements that we’ve defined to show pieces of content that become more interesting when more easily remixable. They may or may not be stale but are left for inspiration.

Football headlines

SELECT
  h3.title.h5 AS headline
, span.date_time__KhlCV.time AS how_long_ago
FROM
  https://www.goal.com/en-us/category/transfers/1/k94w8e1yy9ch14mllpf4srnks
GROUP BY
  div.content-wrapper;

Sequoia’s Fintech investments

SELECT
  td.company-listing__cell-wide.company-listing__text.u-md-hide AS company_tagline
, th.company-listing__cell-wide.company-listing__head AS company_name
, td.u-lg-hide AS company_stage
, li AS investor
FROM
  https://www.sequoiacap.com/our-companies/?_categories=fintech&_sort=stage_current-asc#all-panel
GROUP BY
  tr.aos-init.aos-animate;

Sequoia companies that have gotten acquired

SELECT
  th.company-listing__cell-wide.company-listing__head AS company_name
, td.company-listing__cell-wide.company-listing__text.u-md-hide AS company_function
, td.u-lg-hide AS company_status
, li AS investor
FROM
  https://www.sequoiacap.com/our-companies/?_stage_current=acquired&_sort=stage_current-asc#all-panel
GROUP BY
  tr.aos-init;

Hummingbird VC portfolio company names

SELECT
  p.paragraph.break-spaces.hide-tablet AS what_does_it_do
, p.text-sm.hide-tablet AS location
, p.text-sm AS name
FROM
  https://www.hummingbird.vc/portfolio
GROUP BY
  div.grid-item-row;

Propel VC portfolio company names

SELECT
  a.company-t AS portco
FROM
  https://www.propel.vc/investments
GROUP BY
  div.company_link_cover;

Abstract VC portfolio company names

SELECT
  a AS portco
FROM
  https://www.abstractvc.com/companies
WHERE portco != '' AND portco != 'About' AND portco != '
GROUP BY
  div.MuiGrid-item;

Abstract VC’s portfolio company logos

SELECT
  img.featured-logo AS portco
FROM
  https://abstractvc.com/companies
GROUP BY
  div.featured-inner;

Obligatory demo getting posts from Hacker News

SELECT
  a AS post_title,
  a@href AS post_link
FROM
  https://news.ycombinator.com
GROUP BY
  span.titleline;

Scraping a list of web scraping services from a scraping service website

SELECT
  a@href AS scraping_tool
FROM
  https://www.octoparse.com/blog/top-30-free-web-scraping-software
GROUP BY
  strong;

---

Related: