When I was brainstorming for a business, I have a few items that I want to check-off from my checklist:
Read more · 4 min read
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:
Read more · 2 min read
Los Angeles, CA / Data Analyst / SQL and Python
Get the Medium app