Skip to content

Instantly share code, notes, and snippets.

@kanghyojun

kanghyojun/abc.sql

Created February 22, 2021 08:12
Show Gist options
  • Save kanghyojun/6c5d412cca86c823e96a3cbe0ff2fc4e to your computer and use it in GitHub Desktop.
Save kanghyojun/6c5d412cca86c823e96a3cbe0ff2fc4e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
abc.sql
SELECT
c.name,
o.price
FROM customer AS c
JOIN order AS o ON o.customer_id = c.id
WHERE
o.price > [가격]
ORDER BY o.price DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment