Sign in

When I was brainstorming for a business, I have a few items that I want to check-off from my checklist:


Aggregate Functions (AVG, MAX/MIN, COUNT, SUM)

Above is a wine dataset found on StrataScratch. Suppose we want to write a query to find out what the most expensive wine from each country. We can utilize window function to do this.


I came across a Salesforce SQL Interview question from StrataScratch, at first I thought it was a pretty straightforward, but this question taught me a few things, and I want to share them with you.

Here is the preview of the dataset:

Johan H

Los Angeles, CA / Data Analyst / SQL and Python

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store