kanghyojun/abc.sql

Created February 22, 2021 08:12

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kanghyojun/6c5d412cca86c823e96a3cbe0ff2fc4e.js"></script>
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