data analyst sql interview questions and answers #42/100 | HSBC | SQL Tutorials | EY

Welcome to Day 42 of my 100 Days Challenge!

Get the question
Type !question 400 -- to get first question & datasets
Type !question 373 -- to get second question & datasets

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!

Links:
GitHub Repository - Get the question & datasets

Best Data Analytics Course:

My Other YouTube Videos -
SQL 30 Days Road Map - [Free Learning Resources]

#SQL #DataAnalysis #PortfolioProject #DataCleaning #BusinessAnalysis #DataAnalyst #SQLProject #EDA #SQLTutorial #GitHub #DataScience #CareerInData #LearnSQL #SQLforDataAnalyst #AspiringDataAnalyst #ResumeProject #EndToEndProject

[MathanRJ-pc]

select customer_id, round(avg(amount), 2) as average_amount
from Transactions_zero
where date_format(transaction_date, "%Y-%m") = "2023-09"
group by customer_id
having count(transaction_id) > 5

[zero_analyst]

Start Data Career in 2025 (Best Course)

[rishabhralli]

with cte as(
select *, count(*) over(partition by customer_id) as cn from transactions )
select c.customer_name, a.* from
(select customer_id, round(avg(amount), 2) as avg_amount from cte where cn>5 group by 1)a
inner join customers c on c.customer_id=a.customer_id 2nd question answer

[udaymehta]

superb explanation.
also, very helpful sql bot. Thank you

[Chathur]

with cte as
(
select name
from (
select name, skills, unnest(string_to_array(skills, ', ')) as skills_new
from candidates
)
where skills_new in ('Python', 'Tableau', 'PostgreSQL'))

select distinct name
from cte
group by name
having count(name)>=3
order by name desc

[ManuSachan-pmwx]

I am unable to join in your discord community it's showing invite invalid

[SnapMathShorts]

Hi,
I want to join discord community but it's showing invalid invitation .
please share correct invite link