SQL Query Examples

Get customers

Get customers created past month

Get customers created past month. limit 20.

Get customers created past month and group by email domain

Get customers created past month who haven't made a purchase yet

Get customers who made more than 3 purchases last year and who lives in New York

Get customer with email john@doe.org

Get customer with email john@doe.org with purchases and comments

Get customers within 500m of the Eiffel Tower using lat/lng

Get customers who didn't make a purchase in the last 12 months but a purchase in the 12 months before that

Update all customers starting with a vowel to also start their last name with that vowel

Find customers who made a purchase last year, categorize each by number of purchase and sort by purchases

Create customers table with id, first_name, last_name, email, image_url, created_at, updated_at

Create customers table with id (uuid_generate_v4), first_name (nullable), last_name (nullable), emai...

Add is_premium (default false) to customers

Add index on customers email

Set default value first_name and last_name to John Doe on customers

Rename customers table to users

Create view "Customers NYC" for all customers from New York City

Create view "Expensive Products" that get all products with higher than average price

Create stored procedure for getting customers with city as parameter

Create function for daily created customers