DataLemur 🐵 | Ace the SQL Interview (@datalemurhq) 's Twitter Profile
DataLemur 🐵 | Ace the SQL Interview

@datalemurhq

Follow for SQL Interview tips. Made by @NickSinghTech, Author of Ace the Data Science Interview! Start solving 200+ FAANG SQL/Data questions for FREE 👇

ID: 1551595955287367680

linkhttps://datalemur.com/questions calendar_today25-07-2022 15:51:35

619 Tweet

3,3K Followers

50 Following

DataLemur 🐵 | Ace the SQL Interview (@datalemurhq) 's Twitter Profile Photo
DataLemur 🐵 | Ace the SQL Interview
@datalemurhq

2 years ago

The 5 most common aggregate functions used in SQL interviews are: AVG() - Returns the average value COUNT() - Returns the number of rows MAX() - Returns the largest value MIN() - Returns the smallest value SUM() - Returns the sum Let's practice these on a JP Morgan dataset:

The 5 most common aggregate functions used in SQL interviews are: AVG() - Returns the average value COUNT() - Returns the number of rows MAX() - Returns the largest value MIN() - Returns the smallest value SUM() - Returns the sum Let's practice these on a JP Morgan dataset: