Data Science SQL Interview Question Walkthrough (real interview style) | SQL Sundays #7 | Tina Huang

0:00Energía baja, falta de concentración, nevlamental, y un mal pidi hydrater. Gatorade Zero powders han sido diseñados científicamente para ayudarte a mejorar el balance de hidratación en el cuerpo. Hechos con la mezcla número uno de electrolitos, sin colores ni sabores artificiales, shop now online, or at retailers nationwide. Gatorade hydrates better than water, es de reño. Signos de de hidratación leve y moderada, consulta tu médico si los síndomas persisten. Vizible ocurre en carrying las tres pinchadas de algo pendiente en el gebenorial de dedos, con 76 milísimos porение de las принимas第 5G conmala milí cabeza para sale. Pero aליםahah declínido, lle dus els $19 per帶 sortie de 12 tres piezas, cuando pudiste Atariq grâce 8. Ema sobrio sentidos para subir夠. Ahora accumulate la costavia en la Prayer Ante. Termesador jewelry pasad no 14, Vizible.com para Capture Fulgariances Natural表umbenses y WonderWorked Management Details.

1:28y vamos a ir con otro seco de la Sunday. ¡Está en la escuela! Ok, así es la cuestión que tenemos aquí hoy es de Airbnb Find the minimum average y maximum rental price para cada recorrer de la cualificación de category. La recorrer de la cualificación de category es una recorrer de clasificación y para cada recorrer de la cual es la recorrer de la cualificación de la cual Ok, así es la recorrer de la cualificación de category Ok, vamos a la tabla aquí. Ok, Airbnb, search, y tells, esta es una tabla de la cual hay muchas cosas que vamos a ver. So, we want to look at the recorrer de la cualificación y we are looking at the number of reviews the property has. So, we are basing these clasificación on bad so let's see one of these columns gives us a hint about the number of reviews.

2:33Ok, ok, bathroom blah blah blah blah. Oh, ok, cool. So, number of reviews is literally here. This is really nice. I actually thought that it would be more complex since, you know, maybe it would be like each review and you can aggregate it but Eredi has the number of reviews here for us. That's great. So, let us have a plan as to what we are going to do. So, finally, we want our expected output to look like the reviews qualificación, oops, slice spelling area there, reviews, qualificación, let's comment this out. Main price, average price, and max price. Cool. Alright, so what does assumptions do I have? Ok, so first assumption is that

3:33all the values are going to be in the integer. So, I'm going to assume that we don't have any null values here. Yeah, so I'm going to assume that it's going to be positive integers for this. Well, other things do I have? I think it's about it. Cool. Alright, we can go on to what we're going to do. So, firstly we're going to do is do the classification. And we're going to use case one statements. It should be pretty straightforward and then after we do that, I am going to just do a little bit of just do aggregation. So, group by the rental price, oops, not rental price. Group by qualification category

4:33and then aggregate main, average, and maximum price. Cool. Alright, let's do this query. And then let A will try to make the two essays like wrap-up in the yo. Mostro PAUdad volve Carlos

5:36fue YOU Reviews between 6 y 15, y sa. Quan, Numeros reviews, between 16 y 40, y muchos. Quan, Numeros reviews, Actually, he just do this. Elz, a lot. Cus we're assuming since it's not going to be null and it's going to be positive, so this would catch everything else. That's more than 40 reviews. Okay, so end as, what is it calling it?

6:36Oh yeah, reviews, qualification. So now we can do like a sub query for this, like nested, but I always prefer to use CTs because I just think it's a lot clearer for the interviewer to read and also for your genocid confuse. Oops, one thing, one thing, one thing. We also need a price, right? Cuz we are reading by price. Cool. All right, so let's call this with class with reviews as here, and we can do from reviews. Now we're going to group by qualification category, so let's read this. Energy of ah ha, falta de concentración, nevlamental, you might be dehydrated. Gatorade zero powders, han sido diseñados científicamente

7:38para ayudarte a mejorar el balance de hidratación en el cuerpo. Hechos con la mezcla número uno de lecrolitos, sin coloros ni sabores artificiales, shop now online, or at retailers nationwide. Gatorade hydrates better than water. Ese reño. Signos de de hidratación leve y moderada, consulta tu médico si los síndomas persisten. Visible puts unlimited 5G data and hotspot in the palm of your hand, powered by Verizon's 5G network, with no contract holding you back. And for a limited time, you can get visible for just $19 a month for 12 months when you use promo code save6. All the features of big wireless service, for half the cost. Tap the banner to switch today. Terms apply, standard rate applies at month 13, see visible.com for plan features and network management details. The award-winning American Airlines Advantage Program awards more than travel. It takes your whole life to new heights. Urmiles when you fly, as well as with thousands of your favorite brands.

8:40And then redeem those miles for flights, upgrades, and experiences worldwide. Advantage members also enjoy earlier boarding and free high-speed Wi-Fi in flight. Join for free and start earning towards your next adventure at AA.com slash Spotify. I've seen first, select reviews, qualification. Um, what is it? Minimum, so minimum of price as min price. Abrage as price as average price. And max price. Oh, max price as max price. And then we're going to group by one.

9:44Let's see, let's see. Looks good to me. Fingers crossed, run our code. Oh, no. What happened? Oh, oh, my God. I forgot to write the select statement. Whoops. OK. Requeamistic. OK. This should work now. Yay. OK. Good. We got this right. All right. Is there any other way that we can optimize things? You could use a sub query, like just nest it and not save it as a table. So that would optimize. Actually, no, I don't. Without even optimizing things, that's a good point.

10:46Let's check that out. So let's see, like, CT versus sub query performance. OK. So they're actually the same. Since both provide the same information, you should create an optimizer. Use more than once could be easily identifying how things are going to be stored. OK. So they're actually the same type of performance. So I don't think we can actually optimize it based upon that. And I don't think that we can optimize it in any other way either. OK. So they did us a sub query here. Yeah, it's pretty much the same solution. It's just a sub query. I generally just prefer using CTs as opposed to sub queries. Yep. We're done with this episode. And feel free to check out Stratus Scratch. I will link it below as well. All right. See you guys next time.

12:09I'm not a soldier that I fight. Can you hear me through the silence? I hope your mouth is there. Will we again? Well, me again. I'm not a soldier that I fight. Can you hear me through the silence? I hope your mouth is there. Will we again? Well, me again. Well, me again. Everything we wanted turned to gold. The past we chose, the future on our side. Never thought I'd do this on my own. But now I will be sword left behind. The oak tree where I met you, and the writing on the statue.

13:14I still remember how say where you said. I'm not a soldier that I fight. Can you hear me through the silence? I hope your mouth is there. Will we again? Well, me again. Well, me again. I'm not a soldier that I fight.

14:14I'm not a soldier that I fight. Can you hear me through the silence? I hope your mouth is there. Will we again? Well, me again. Well, me again. Well, me again.

15:14The future is described as only a novel and not a medical use. Based on Apple's study of heart rate accuracy in August of 2016, Apple Watch Series 12. This is sick! Have a tar fire and ash. Now stream on Disney Plus. Ready, Pigeon 13.

16:14So if you're looking to serve a meal, your dog actually looks forward to every single day, they should totally just eat Caesar. Learn more at Caesar.com. This is US Bank's Cozy Cash Remations, with your chief financial playmaker for Nando Mendoza. You are worthy of financial security. Budgeting is not restriction. It's freedom. You are smart. You are capable. You are giving your money a purpose. You are learning the language of saving, of growing, now streaming. Member FDIC Copyright 2026, US Bank.