Intro Today, we will solve a problem about list in python. Since we know the list structure, there seems to be nothing to write about the concept. So I'll move on to the problem right away. Here's the problem we will solve today : Baekjun 10808. Because it comes out in the lecture I've watch. The process I 've solvedFirst of all, I got input to l. And the problem said that only lowercase letters..

IntroEven though I made a correction on my second journey, my Blog failed to be approved by Adsense. The approval status shows the needs attention, and even the Ads.txt status is still not found. In addition, their statement that the number of site review requests has been used up, so I can request again from July 15, 2024. This means that I have to run more towards one post per day for at least..

IntroI'd like to introduce an app called jump desktop. The reason is that I'm using it very well. First of all, I'll give someone who live in other region a small tip before the start. It's 22,000 KRW if you buy it in Korea, but what if you buy it in dollars? It's 15 USD. It means that if you buy it in dollars, it was around 18,000 KRW. So before a purchase, compare curreny and price between you..

To get to know about SELF JOIN & DATE type format, let's solve Leetcode problem in https://leetcode.com/problems/rising-temperature/ . If you want to know about SELF JOIN, you can go HERE.What this asking for is, "Select 'ID' with a higher temperature than yesterday." And here's the Weather table.Weather table:+----+------------+-------------+| id | recordDate | temperature |+----+------------+-..

What is MySQL SELF JOIN?MySQL을 공부하며 제일 헷갈리는게 조인인데 (left join, right join, inner join 등등등) SELF JOIN이라는 놈도 있다ㅋㅋ SELF JOIN이란 무엇인가 . . 쉽게 말하면 자기 자신을 조인하는 놈이다. 여기서 생기는 의문The most confusing thing studying MySQL is JOIN (including left join, right join, inner join, etc.). There is also a thing called SELF JOIN. Then, "What is SELF JOIN??". Simply put, It is the one who joins itself literally. The que..

There is a challenge in HackerRank. We should find the result of abandoning the decimal point abandoned, not rounded up. How do we deal with decimals in MySQL? we've seen the round. But we've rarely seen abandonment before. Anyway, let's find out how to solve the problem of dealing with decimal points.MySQL Decimal Abandonment(Down) MethodThe way to abandon the decimal point is to use FLOOR righ..

When you need to include a NULL value?From now on, if there is a null value in the SQL table as shown in the following table, we have to be careful. Because there is a problem, not a problem. It's even more concerning that it's not considered a problem.IDNUMName142A232B3NULLVSELECT COUNT(*) NAME FROM table; -- result : 3SELECT COUNT(NUM) NAME FROM table; -- result : 2If we look at the table abov..