Skip to content

Instantly share code, notes, and snippets.

Created Jun 11, 2020
What would you like to do?
Give FirstNames of People from Minnesota with amount_due more than $100
WITH basic AS
FROM basic_details
WHERE lower(gender) = 'male' ), bill AS
FROM bil_details
WHERE CAST(amount_due AS INTEGER) > 100 ), contact AS
FROM contact_details
JOIN bill
ON =
WHERE state= 'Minnesota' )
SELECT basic.first_name
FROM basic
JOIN contact
ON =
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment