쉐도잉 연습: Solving Easy SQL Interview Questions on Analyst Builder - 영상으로 영어 말하기 배우기

연습 모드 선택

각 모드는 전체 화면 연습실로 열립니다.

205 문장

문장이 너무 짧거나 길면 Edit를 눌러 조정하세요.

What's going on, everybody?

Welcome back to another video.

Today, we are going to be solving easy SQL technical interview questions.

Now, when I was interviewing for data analyst positions, I almost always got some type of technical interview.

And the vast majority of the technical interviews that I got were in SQL.

Not only that, but I was also on a hiring team and later as a hiring manager,

I almost always conducted some type of SQL technical interview.

Now, why do hiring managers conduct these interviews.

It's because they want to make sure that you actually know the skill

because you can just put SQL on your resume and not actually know it at all.

And then when they hire you, they have to spend two,

three, four months training you on the basics of SQL for you to actually understand it and use it.

That is not what any hiring manager wants.

And so that's why they conduct these SQL technical interviews.

So in this series, we're going to start with easy questions.

That'll be in today's video.

Then we'll go on to medium, hard, and then very hard SQL technical interview questions.

So without further ado, let's jump onto my screen and take a look at the easy SQL interview questions.

We're gonna be practicing these questions on analystbuilder .com.

And if we come right over here, we can filter to the free questions and we can filter to the easy questions.

These are all the free and easy questions that you can go and take right now.

I will leave a link in the description.

I will also leave a link to the two questions that we're gonna be looking at today,

but go ahead and check out this if you wanna try out all of these different questions.

There's also different difficulties.

So we're gonna be working through the moderate it and the hard ones in future videos.

And then we'll also be looking at the very difficult ones in the very last video in this series.

But let's go ahead and get rid of this because we're going to go over to our very first question.

Now, really quickly, I just want to show you the interface before we actually dive into the question.

Now, we're going to be solving this in MySQL, but you can also practice in PostgreSQL and Microsoft SQL Server,

whichever one you have an interview coming up for.

If that company uses

Microsoft SQL Server, come in here and use

Microsoft SQL Server.

And we also have

Python as well.

But we're going to be doing this in MySQL.

This is where we'll write our actual SQL code.

Then we have the prompt.

Now in an interview, typically they're going to give you some type of prompt and then the data.

They're going to ask you to do something with the data.

And our data is right down here.

So this is our data.

Now this is a practicing platform, right?

To practice for technical interview questions or practice for your technical interviews.

So we also have hints and expected output, as well as a video explanation walking through this question, showing you exactly how to do it.

But if you can't get it at all, you can always come in here and look at the solution for any of these.

But let's go ahead and start this question.

The question is called car failure.

It says, cars need to be inspected every year in order to pass inspection and be street legal.

If a car has any critical issues, it will fail inspection or if it has more than three minor issues, it will also fail.

Write a query to identify the cars that passed inspection.

Outputs should include the owner name and vehicle name ordered by the owner name alphabetically.

Now, let's go take a look at this data.

So we have the owner name, vehicle name, minor issues, critical issues, and that's all we have.

So it's just a simple one.

Again, this is an easy question, at least on Analyst Builder and

so let's try to solve this without any of the hints

or looking at the expected output because I think we can solve this one.

Now, the first thing that we need to take into consideration is we're going to need to be filtering.

So we'll need to filter down some data.

So if a car has any critical issues, it'll fail.

So if critical issues is one, two, three, it's going to fail.

So it can't have no critical issues

and they'll say and cause even though this says

or right here it doesn't mean one or the other it means

if it has this or it has this it fails

so we actually need an and here so both conditions need to be met or more than three minor issues

so you can't have either of those

now in our output for what we're going to get down here we need to have just two things

We just need the owner name and vehicle name.

So let's put that owner name and vehicle name.

And then lastly, we just have to order by the owner name.

And that's going to be ascending, ASC.

Ascending is just A to Z.

So I think we can go ahead and start writing this out because I think that's all we need to do.

Now let's go ahead and run this.

And so we have our data right down here.

Now here's what we need to do.

We are trying to identify cars that passed the inspection.

So we need to filter out the ones that had a critical issue or that had three or more minor issues.

So what we're gonna do is we're gonna come right over here.

And the first one we'll do is critical issues.

So we're gonna say where critical underscore issues.

And we need to say it's equal to zero.

And let's run this.

And it looks like I had a space here.

Let's run this again.

There we go.

So now, these are cars that have no critical issues.

So these ones are passing.

But if we just look at our data right down here, we have some that have four, four, five.

So we also have to say, and, and I'm going to copy this so I don't have another problem with that.

So, I'm going to say where it's less than or equal to, then I'm going to say 3.

So, if it has 3 or less, it should be in our output.

So, let's run this.

And I say greater than.

Let me do less than.

There we go.

100

And we can see that now the minor issues are all 3 or less.

101

And let's just make sure.

102

Or if it has more than 3.

103

So, if it had 4 or 5, it should not be in our output it.

104

So these has 320222 and this has 0000.

105

So these are cars that should pass.

106

Now right now we've been selecting everything, but what we really need to do is just select the columns that we need.

107

That's going to be owner underscore name and vehicle.

108

So let's run this.

109

And this looks really good.

110

And the last thing that we need to do is order by.

111

So we need to order by the owner name.

112

Let's get that owner name.

113

And we need to do that in ascending.

114

Now, by default, when you use order by to organize and sort a column, it automatically is in ascending,

115

but I like to at least put it there explicitly so I can see it.

116

And this to me should be the correct answer.

117

Now, what we need to do to check our answer

118

and actually show if we got the answer right is just click this check answer button.

119

We can also do control shift enter, but I'm going to click the check answer.

120

And there we go.

121

We got the solution correct.

122

So let's go ahead and come up here.

123

We're going to go to our next question.

124

This is another easy question on Analyst Builder.

125

Again, I'm going to leave a link in the description if you want to try out this exact question.

126

But let's take a look at this one.

127

This is called Apply Discount.

128

It says a computer store is offering a 25 % discount for all new customers over the age of 65

129

or customers that spend more than $200 on their first purchase.

130

The owner wants to know how many customers received that discount since they started the promotion.

131

Write a query to see how many customers received that discount.

132

Okay.

133

And let's go down and look at the data.

134

So we have customer ID, we have their age, and then we have their total purchase.

135

And let's just see if there's any duplicates in this customer ID.

136

It doesn't look like it.

137

It looks like they're all just one purchase.

138

The reason I was looking at that is it says all new customers, and it looks like these are all new customers.

139

It doesn't look like there's any repeat customers that are old customers.

140

So we're going to assume these are all new customers.

141

If there was a multiple 1 ,001s, I would look for something like a transaction ID or a transaction date,

142

but those types of questions are usually a little bit more difficult in like the medium hard types of questions.

143

But let's go make some notes real quick.

144

So we have to filter on two different things.

145

They have to meet one of these criteria in order to be in the output.

146

They either have to be over the age of 65, so over 65, and let's do over 65,

147

or they just have to meet one of these, or have spent more than 200, or spent more than 200.

148

And that shouldn't be capitalized.

149

So that's what we need

150

And then the owner is just wanting to know

151

How many customers received that discount

152

So we're going to do a count

153

On the number of customers

154

That fit that filter I'll write it like that

155

So it's just going to be a number in our output

156

This one should be I would say even a little bit

157

Simpler than the last one

158

Because we're not having to filter

159

Or really do anything like that

160

Now let's run this

161

And let's come down here.

162

So we're gonna do a count eventually on this customer ID,

163

but what we need to do is filter on both the age and the total purchase.

164

So let's write this out.

165

So age needs to be, and I need to write where, where age is greater than 65.

166

Now, I'm not saying greater than or equal to, because right here it says for new customers over the age of 65.

167

If it said age 65 or over, I would say greater than or equal to.

168

I want to be, these questions can be very specific.

169

And then we'll say and, or actually or, because it's either of these need to be true.

170

Or the total purchase.

171

And again, it says more than 200.

172

So we're going to say greater than 200.

173

Now let's run this.

174

And let's just kind of look down here.

175

There's a lot of people that fit this bill, it looks like.

176

Yeah, the majority of people, that's great.

177

So we're gonna give them a discount.

178

These are people that received a discount.

179

So all we're gonna do is account on this customer ID.

180

So let's do account on customer ID.

181

Let's run this, and our answer is 14.

182

All we have to do is check this answer to make sure it is correct.

183

So let's hit the check answer, and there we go your solution is correct.

184

Now, one thing I will say about just technical interviews in general is oftentimes

185

they want to make sure you know how to write it, but even more so, they're really checking to make sure you understand how SQL works.

186

So when I'm writing this out, if I'm in an actual interview, I would be talking this out loud to the interviewer who's interviewing me.

187

I would say, okay, it looks like I need to filter on this

188

and I need to do a count on these things.

189

Now, you only would know how to do that if you know MySQL or if you know SQL, right?

190

Again, they really wanna hear your thought process.

191

And so walking through it exactly how I did in the actual interview is exactly what the interviewer wants to hear.

192

Now, writing it correctly is still very important, especially as you get to the more difficult questions, right?

193

You want to know certain functions and certain ways to write things, but you should be talking all this out loud during your interview.

194

Now, one other really cool thing, I'm just going to show you this at the end is if I go over to my profile,

195

I'm actually earning points for these questions.

196

So right down here, I just earned a couple extra points towards my MySQL badge

197

and I can go all the way up to expert and then master as well.

198

And so I am well on my way.

199

And then in future videos, when we do the medium and the hard and then the very hard questions,

200

we earn even more points for those because they are more difficult and they go towards these badges.

201

So that is how we solve those easy SQL technical interview questions on Analyst Builder, go ahead and try those out.

202

There's tons of other free questions on the platform that you can just try out.

203

And there's lots of easy ones, but then we're also gonna be taking a look at medium, hard, and very hard in future lessons.

204

With that being said, I hope you enjoyed this video.

205

If you did, be sure to like and subscribe below, and I will see you in the next video.

앱 다운로드

유창하게 말하는 데 필요한 모든 것

AI 발음 평가문장마다 점수 확인

IPA 발음 연습모든 소리 마스터

단어 학습나만의 단어장 만들기

단어 게임놀면서 외우기

QR 스캔

Download on theApp Store Get it onGoogle Play

같은 채널

FOR YOU

이 레슨의 어휘와 말하기 포인트

이 말하기 레슨은 영상 “Solving Easy SQL Interview Questions on Analyst Builder”을(를) 바탕으로 합니다. 가장 자주 반복되는 단어는 다음과 같습니다: customer, interview, Sql, issue, owner. 이 영상에는 섀도잉할 문장 205개와 단어 2342개가 있습니다. 말하는 구간의 길이는 12:05입니다. 화자는 분당 약 194단어로 빠르게 말하므로 연음과 약하게 발음되는 소리가 많습니다. 단어의 90%가 영어에서 가장 많이 쓰이는 3,000단어에 속해 어휘가 쉬운 편입니다.

이 영상의 핵심 어휘

영상에 나오는 익혀 둘 만한 단어 15개를 발음, 뜻과 함께 정리했습니다.

단어	발음	뜻
filter 명사	/ˈfɪltɚ/	여과기, 필터
output 명사	/ˈaʊtpʊt/	출력
discount 명사	/ˈdɪskaʊnt/	할인
solve 동사	/sɒlv/	해결하다
hire 동사	/ˈhaɪɹ/	고용하다
inspection 명사	/ɪnˈspɛkʃən/	검사
earn 동사	/ɝn/	벌다
select 동사	/sɪˈlɛkt/	고르다
transaction 명사	/tɹænˈzækʃən/	처리
hint 명사	/hɪnt/	힌트, 실마리
badge 명사	/bæd͡ʒ/	배지
prompt 동사	/pɹɑmpt/	부추기다
query 명사	/ˈkwɪɹ.i/	질문
interviewer 명사	/ˈɪntɚvjuɚ/	면접관
vast 형용사	/væst/	광대하다, 거대하다

영상에 나오는 구동사

단어	뜻
come down 동사	내려오다
come up 동사	올라오다
go down 동사	내려가다

따라 말해 볼 만한 문장

영상에 나오는 짧고 완결된 문장으로, 일상 대화에서 그대로 쓸 수 있습니다:

We're gonna be practicing these questions on analystbuilder .com.
Let's get that owner name.
We're going to go to our next question.
I'm actually earning points for these questions.

주의할 발음

화자는 we're, gonna, I'm 같은 축약형과 약화된 형태를 66번 사용합니다. 들리는 대로 짧게 발음하세요.

“sh”와 “zh” 소리: inspection /ɪnˈspɛkʃən/, transaction /tɹænˈzækʃən/, explanation /ˌɛkspləˈneɪʃən/, promotion /pɹəˈmoʊʃn̩/, consideration /kənˌsɪd.əˈɹeɪ.ʃən/
긴 단어 — 강세 위치에 주의: explanation /ˌɛkspləˈneɪʃən/, difficulty /ˈdɪfɪkəlti/, consideration /kənˌsɪd.əˈɹeɪ.ʃən/, capitalize /ˈkæpətəˌlaɪz/, criterion /kɹaɪˈtɪɹ.i.ən/

한국어 화자가 어려워하는 소리:

/f/ — ㅍ(/p/)으로 바꾸지 말고 윗니를 아랫입술에 대기: filter /ˈfɪltɚ/, difficulty /ˈdɪfɪkəlti/, default /dɪˈfɔlt/, interface /ˈɪn(t)ɚˌfeɪs/, oftentimes /ˈɔf.ənˌtaɪmz/
/v/ — ㅂ(/b/)과 구별하기: solve /sɒlv/, interviewer /ˈɪntɚvjuɚ/, vast /væst/, dive /daɪv/, whichever /wɪt͡ʃˈɛvɚ/
/z/ — ㅈ이 아니라 성대를 울리는 /s/: transaction /tɹænˈzækʃən/, resume /ˈɹɛz.ə.meɪ/, organize /ˈɔɹɡənaɪz/, columns /ˈkɑləmz/, capitalize /ˈkæpətəˌlaɪz/

이 영상으로 연습하는 방법

먼저 말하지 않고 영상을 끝까지 듣고 모르는 단어를 적어 둡니다.
0.75배속으로 한 문장씩 섀도잉을 시작하고, 익숙해지면 보통 속도로 돌아갑니다.
자신의 목소리를 녹음해 원본과 비교하고, filter, output, discount 같은 단어에 특히 주의합니다.

쉐도잉이란? 영어 실력을 빠르게 키우는 과학적 방법

쉐도잉(Shadowing)은 원래 전문 통역사 훈련을 위해 개발된 언어 학습 기법으로, 다언어 학자인 Dr. Alexander Arguelles에 의해 대중화된 방법입니다. 핵심 원리는 간단하지만 매우 강력합니다: 원어민의 영어를 들으면서 1~2초의 짧은 지연으로 즉시 소리 내어 따라 말하는 것——마치 '그림자(shadow)'처럼 화자를 따라가는 것입니다. 문법 공부나 수동적인 청취와 달리, 쉐도잉은 뇌와 입 근육이 동시에 실시간으로 영어를 처리하고 재현하도록 훈련합니다. 연구에 따르면 이 방법은 발음 정확도, 억양, 리듬, 연음, 청취력, 말하기 유창성을 크게 향상시킵니다. IELTS 스피킹 준비와 자연스러운 영어 소통을 원하는 분들에게 특히 효과적입니다.

섀도잉 방법: 단계별 전체 가이드 읽기 →

쉐도잉 연습: Solving Easy SQL Interview Questions on Analyst Builder - 영상으로 영어 말하기 배우기

연습 모드 선택

앱 다운로드

같은 채널

What are KPIs and Metrics? | Data Fundamental for Beginners

FREE Data Analyst Bootcamp!!

Installing MySQL and Creating Databases | MySQL for Beginners

Database vs Data Warehouse vs Data Lake | What is the Difference?

추천 영상

Answering behavioral interview questions is shockingly uncomplicated

FULL Data Science Mock Interview | SQL, Statistics, Business

Every Cybersecurity Interview Question and Answer in 35 minutes

10 Data Analyst Interview Questions and Answers - Senior Data Analyst Explains

The unfair way I got good at Leetcode

FullStack Interview Questions (Junior & Mid)

QUALITY CONTROL Interview Questions & Answers! (Inspector, Manager + Assessor Interview Questions!

think like a business analyst in tech (3 core skills + solving case study)

Job Interview Connected Reading | 英语连读面试

My Senior UX Design Interview Experience | tips, questions, prep, & more!

17 QUESTIONS TO ASK AT THE END OF A JOB INTERVIEW! (GET HIRED FAST!)

🔥HR Interview Questions and Answers (2025) | Top HR Interview Questions for Freshers | Intellipaat

이 레슨의 어휘와 말하기 포인트

이 영상의 핵심 어휘

영상에 나오는 구동사

따라 말해 볼 만한 문장

주의할 발음

이 영상으로 연습하는 방법

쉐도잉이란? 영어 실력을 빠르게 키우는 과학적 방법

쉐도잉 연습: Solving Easy SQL Interview Questions on Analyst Builder - 영상으로 영어 말하기 배우기

연습 모드 선택

앱 다운로드

What are KPIs and Metrics? | Data Fundamental for Beginners

FREE Data Analyst Bootcamp!!

Installing MySQL and Creating Databases | MySQL for Beginners

Database vs Data Warehouse vs Data Lake | What is the Difference?

Answering behavioral interview questions is shockingly uncomplicated

FULL Data Science Mock Interview | SQL, Statistics, Business

Every Cybersecurity Interview Question and Answer in 35 minutes

10 Data Analyst Interview Questions and Answers - Senior Data Analyst Explains

The unfair way I got good at Leetcode

FullStack Interview Questions (Junior & Mid)

QUALITY CONTROL Interview Questions & Answers! (Inspector, Manager + Assessor Interview Questions!

think like a business analyst in tech (3 core skills + solving case study)

Job Interview Connected Reading | 英语连读 面试

My Senior UX Design Interview Experience | tips, questions, prep, & more!

17 QUESTIONS TO ASK AT THE END OF A JOB INTERVIEW! (GET HIRED FAST!)

🔥HR Interview Questions and Answers (2025) | Top HR Interview Questions for Freshers | Intellipaat

이 레슨의 어휘와 말하기 포인트

이 영상의 핵심 어휘

영상에 나오는 구동사

따라 말해 볼 만한 문장

주의할 발음

이 영상으로 연습하는 방법

쉐도잉이란? 영어 실력을 빠르게 키우는 과학적 방법

Job Interview Connected Reading | 英语连读面试