SQL Challenge #16/100 | Group By + Interview Questions + Tutorials ! American Express Data Analyst

Welcome to Day 14 of my 100 Days Challenge! Today, we're diving into American Express SQL interview questions to help you ace your next tech interview.
Join me as I walk through each problem step-by-step, providing detailed explanations and practical tips. Don't forget to like, subscribe, and hit the bell icon to stay updated with daily challenges!
Get the question & datasets
github.com/naji...
Join the 100 Days Challenge Community:
Discord: / discord
/ discord
/*
Follow me in LinkedIn :: / najirr
Follow me in insta :: / zero_analyst
Subscribe to our youtube channel :: / @zero_analyst
*/
#AmazonInterview #SQLInterviewQuestions #100DaysChallenge #DataScience #SQLTutorial #TechInterviews #DataAnalysis #LearnSQL #InterviewPrep #CodingChallenge #TechCareer #SQLPractice #AmazonTech #DataEngineering #PythonInterview #ExcelTips"
#AmazonInterview #SQLInterviewQuestions #100DaysChallenge #DataScience #SQLTutorial #TechInterviews #DataAnalysis #LearnSQL #InterviewPrep #CodingChallenge #TechCareer #SQLPractice #AmazonTech #DataEngineering #PythonInterview #ExcelTips"
www.zeroanalyst.com
/ zero_analyst
Tags:
#SQL #DataAnalyst #GroupBy #SQLTutorial #DataAnalysis #LearnSQL #SQLQueries #GroupByClause #SQLForBeginners #DataScience #SQLTraining #TechSkills #CareerGrowth #DataVisualization #SQLFunctions #AggregateFunctions #DataInsights
Don't Forget to Like, Comment, and Subscribe!
If you find this video helpful, please give it a thumbs up, share it with your friends, and subscribe to our channel for more data analysis tutorials. Your support helps us create more valuable content for you.

[@AmbarGharat]

Great Explanation! Please only take these level of difficulty questions as mostly companies asking hard level questions.

[@harishparamathmananda1385]

👏super spirit🎉
Thanks for providing selfless services even on Sunday 🔥

[@deepthim2837]

Thankyou for your explaination

[@zero_analyst]

Thanks for sharing the interview question! ❤

[@ankitsharma4240]

So here we have transaction date also....what if in 1st transaction only he has made transction greater than limit

[@vinothkumars7421]

84 days to go

[@gamerntube7475]

which software are you using.. i am using mysql software i cant update the tables from your github its show some error

[@vinothkumars7421]

its postgres. You need to change the syntax as er mysql

[@VanshGudka]

SELECT u.user_id, u.user_name, u.credit_limit, SUM(t.amount) AS total_spent
FROM users u
JOIN trans t ON u.user_id = t.paid_by
GROUP BY u.user_id, u.user_name, u.credit_limit
HAVING SUM(t.amount) > u.credit_limit;
Is it right ?