본문 바로가기

Category87

Mini Project - Changes in Wine Taste Trends Over the Years Mini Project Changes in Wine Taste Trends Over the Years We started the project with a team consisting of five members from different background but everyone wants to become a data analysis. Our team name is 'mini 4t', and for our first mini project together, we conducted data analysis. We utilized a wine information database from Kaggle to examine the trend of changes in wine taste over the yea.. 2024. 4. 16.
WIL : Weekly I Learned 12.04.2024 Fact During this past week, I continued studying SQL and Python. Starting from next week, I will be diving into the main course, and I have planned to study for over 12 hours per day for half of year. Throughout the week, I solved SQL and Python code kata questions, and I solved nearly 100 questions in total from the code kata. And This is what I solved for this week from LeetCode SQL quetions. .. 2024. 4. 12.
1934. Confirmation Rate While I was trying to solve below SQL question on LeetCode, I encountered an unfamiliar issue. In order to solve the problem, I attempted to use 'case when' to calculate the counts of 'timeout' and 'confirmed', and then utilize the sum to derive the value of 'confirmation_Rate'. However, despite multiple attempts, I couldn't solve it due to errors in the code. Table: Signups +----------------+--.. 2024. 4. 12.
Having The HAVING clause in SQL is used to filter the result set returned by a GROUP BY clause.  It allows you to apply conditions to groups of rows rather than individual rows.  This is particularly useful when you want to filter groups based on aggregate functions, such as SUM, AVG, MIN, MAX, etc. Here are some examples:  Using SUM with HAVING:SELECT department, SUM(sales) AS total_salesFROM sales_ta.. 2024. 4. 11.
Modeling In SQL, modeling refers to the process of designing and defining the structure of a database. It involves defining tables, columns, relationships, and constraints to meet the requirements of the database. Modeling in SQL typically includes the following elements: Conceptual Modeling: Conceptual modeling involves designing the overall structure of the database based on business requirements and c.. 2024. 4. 9.
The count of divisors and addition Two integers, left and right, are given as parameters. Complete the solution function to return the sum of numbers from left to right, where the count of divisors is even, and subtract the sum of numbers where the count of divisors is odd. When I first encountered this question, my initial approach was to first find the divisors, then distinguish between even and odd counts, and finally proceed .. 2024. 4. 9.

티스토리툴바