bartubozkurt/except.sql

Created June 11, 2021 19:28

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

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/bartubozkurt/0db246b6a949316d3ffc701d62217413.js"></script>
Save bartubozkurt/0db246b6a949316d3ffc701d62217413 to your computer and use it in GitHub Desktop.

Download ZIP

Displays DE cyclists unless they are also DE skaters at the same time

Raw

	SELECT name
	FROM cycling
	WHERE country = 'DE'
	EXCEPT
	SELECT name
	FROM skating
	WHERE country = 'DE';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment