Comment by im3w1l

Tbh I often find I would like to use variables in sql. Something like

  americans := SELECT username FROM users WHERE country = "us";
  SELECT url, visits FROM posts, americans ON posts.author = americans.username ORDER BY visits DESC LIMIT 10;