Here’s an example using standard grammar:
SELECT
a AS post -- Saving the text in [a] elements as "post"
, a@href AS link -- Saving the [href] attribute of [a] elements as "link"
FROM
https://news.ycombinator.com
GROUP BY
span.titleline;
For an alternative grammar that’s more functional and offers additional features, learn about the pipe operator syntax