@palmarea.bsky.social
Hiii, random stuff that I do and hope can help you one day. Mission zine! ✨
Day 21 of advent calendar on sql !! 🎄🎅
📊 Report at the end.
Snow Queen's 24-day storytelling marathon shows strategic pacing with Christmas Eve climax. Consistent engagement throughout.
✅ Window functions: SUM+OVER
✅ Chronological ordering
✅ Running total tracking
📊 Report at the end.
Snow Queen's 24-day storytelling marathon shows strategic pacing with Christmas Eve climax. Consistent engagement throughout.
✅ Window functions: SUM+OVER
✅ Chronological ordering
✅ Running total tracking
December 21, 2025 at 5:57 PM
Day 21 of advent calendar on sql !! 🎄🎅
📊 Report at the end.
Snow Queen's 24-day storytelling marathon shows strategic pacing with Christmas Eve climax. Consistent engagement throughout.
✅ Window functions: SUM+OVER
✅ Chronological ordering
✅ Running total tracking
📊 Report at the end.
Snow Queen's 24-day storytelling marathon shows strategic pacing with Christmas Eve climax. Consistent engagement throughout.
✅ Window functions: SUM+OVER
✅ Chronological ordering
✅ Running total tracking
Day 20 of advent calendar on sql !! 🎄🎅
5DLEFT!? Jack wants to review cocoa braeks, ype and location he drank it in:
✅ Combining multiple tables using `JOIN`
✅ Understanding foreign key relationships
✅ Retrieving descriptive data instead of IDs
✅ Reading relational logic from plain English
5DLEFT!? Jack wants to review cocoa braeks, ype and location he drank it in:
✅ Combining multiple tables using `JOIN`
✅ Understanding foreign key relationships
✅ Retrieving descriptive data instead of IDs
✅ Reading relational logic from plain English
December 21, 2025 at 12:32 PM
Day 20 of advent calendar on sql !! 🎄🎅
5DLEFT!? Jack wants to review cocoa braeks, ype and location he drank it in:
✅ Combining multiple tables using `JOIN`
✅ Understanding foreign key relationships
✅ Retrieving descriptive data instead of IDs
✅ Reading relational logic from plain English
5DLEFT!? Jack wants to review cocoa braeks, ype and location he drank it in:
✅ Combining multiple tables using `JOIN`
✅ Understanding foreign key relationships
✅ Retrieving descriptive data instead of IDs
✅ Reading relational logic from plain English
Day 19 of advent calendar on sql !! 🎄🎅
Calculating totals with conditions
✅ Filtering rows with WHERE
✅ Using BOOLEAN columns in conditions
✅ Applying aggregate functions (SUM)
Calculating totals with conditions
✅ Filtering rows with WHERE
✅ Using BOOLEAN columns in conditions
✅ Applying aggregate functions (SUM)
December 20, 2025 at 3:46 PM
Day 19 of advent calendar on sql !! 🎄🎅
Calculating totals with conditions
✅ Filtering rows with WHERE
✅ Using BOOLEAN columns in conditions
✅ Applying aggregate functions (SUM)
Calculating totals with conditions
✅ Filtering rows with WHERE
✅ Using BOOLEAN columns in conditions
✅ Applying aggregate functions (SUM)
Day 18 of advent calendar on sql !! 🎄🎅
How much did she improved? We'll find first and last score per subject:
✅ window functions with `PARTITION BY`
✅ `FIRST_VALUE()` and `LAST_VALUE()`
✅ window frame explicitly
✅ and read business logic from plain English
How much did she improved? We'll find first and last score per subject:
✅ window functions with `PARTITION BY`
✅ `FIRST_VALUE()` and `LAST_VALUE()`
✅ window frame explicitly
✅ and read business logic from plain English
December 19, 2025 at 3:46 AM
Day 18 of advent calendar on sql !! 🎄🎅
How much did she improved? We'll find first and last score per subject:
✅ window functions with `PARTITION BY`
✅ `FIRST_VALUE()` and `LAST_VALUE()`
✅ window frame explicitly
✅ and read business logic from plain English
How much did she improved? We'll find first and last score per subject:
✅ window functions with `PARTITION BY`
✅ `FIRST_VALUE()` and `LAST_VALUE()`
✅ window frame explicitly
✅ and read business logic from plain English
Day 17 of advent calendar on sql !! 🎄🎅
Cindy Lou appears! She would like the tasks to be categorized by noise level (CASE WHEN :)
✅ Creating conditional logic with CASE WHEN
✅ Classifying rows based on numeric thresholds
✅ Creating new categorical columns
✅ Reading business rules from plain English
Cindy Lou appears! She would like the tasks to be categorized by noise level (CASE WHEN :)
✅ Creating conditional logic with CASE WHEN
✅ Classifying rows based on numeric thresholds
✅ Creating new categorical columns
✅ Reading business rules from plain English
December 18, 2025 at 12:43 AM
Day 17 of advent calendar on sql !! 🎄🎅
Cindy Lou appears! She would like the tasks to be categorized by noise level (CASE WHEN :)
✅ Creating conditional logic with CASE WHEN
✅ Classifying rows based on numeric thresholds
✅ Creating new categorical columns
✅ Reading business rules from plain English
Cindy Lou appears! She would like the tasks to be categorized by noise level (CASE WHEN :)
✅ Creating conditional logic with CASE WHEN
✅ Classifying rows based on numeric thresholds
✅ Creating new categorical columns
✅ Reading business rules from plain English
Day 16 of advent calendar on sql !! 🎄🎅
Helping Buddy decide which tasks he can do from under the blanket. 'Work From Home' or 'Low Priority tasks only'.
✅ Filtering rows using `WHERE`
✅ Logical operators (`OR`)
✅ Selecting specific conditions from a table
✅ Plain English → SQL
Helping Buddy decide which tasks he can do from under the blanket. 'Work From Home' or 'Low Priority tasks only'.
✅ Filtering rows using `WHERE`
✅ Logical operators (`OR`)
✅ Selecting specific conditions from a table
✅ Plain English → SQL
December 16, 2025 at 3:29 PM
Day 16 of advent calendar on sql !! 🎄🎅
Helping Buddy decide which tasks he can do from under the blanket. 'Work From Home' or 'Low Priority tasks only'.
✅ Filtering rows using `WHERE`
✅ Logical operators (`OR`)
✅ Selecting specific conditions from a table
✅ Plain English → SQL
Helping Buddy decide which tasks he can do from under the blanket. 'Work From Home' or 'Low Priority tasks only'.
✅ Filtering rows using `WHERE`
✅ Logical operators (`OR`)
✅ Selecting specific conditions from a table
✅ Plain English → SQL
Day 15 of advent calendar on sql !! 🎄🎅
The Grinch wants to see how his mischief score changes each day compared to the previous day.
✅ Comparing rows using window functions
✅ LAG() to access the previous row
✅ Calculated columns based on previous values
✅ Tracking daily increases or decreases
The Grinch wants to see how his mischief score changes each day compared to the previous day.
✅ Comparing rows using window functions
✅ LAG() to access the previous row
✅ Calculated columns based on previous values
✅ Tracking daily increases or decreases
December 16, 2025 at 4:09 AM
Day 15 of advent calendar on sql !! 🎄🎅
The Grinch wants to see how his mischief score changes each day compared to the previous day.
✅ Comparing rows using window functions
✅ LAG() to access the previous row
✅ Calculated columns based on previous values
✅ Tracking daily increases or decreases
The Grinch wants to see how his mischief score changes each day compared to the previous day.
✅ Comparing rows using window functions
✅ LAG() to access the previous row
✅ Calculated columns based on previous values
✅ Tracking daily increases or decreases
Day 14 of advent calendar on sql !! 🎄🎅
Helping Productivity Club to calculate each member’s focus_end_date, 14 days after their start_date
✅ Days to a date using SQLite
✅ Creating calculated columns with DATE()
✅ Date modifiers ('+14 days')
✅ Returning the original table plus a new column
Helping Productivity Club to calculate each member’s focus_end_date, 14 days after their start_date
✅ Days to a date using SQLite
✅ Creating calculated columns with DATE()
✅ Date modifiers ('+14 days')
✅ Returning the original table plus a new column
December 14, 2025 at 6:23 PM
Day 14 of advent calendar on sql !! 🎄🎅
Helping Productivity Club to calculate each member’s focus_end_date, 14 days after their start_date
✅ Days to a date using SQLite
✅ Creating calculated columns with DATE()
✅ Date modifiers ('+14 days')
✅ Returning the original table plus a new column
Helping Productivity Club to calculate each member’s focus_end_date, 14 days after their start_date
✅ Days to a date using SQLite
✅ Creating calculated columns with DATE()
✅ Date modifiers ('+14 days')
✅ Returning the original table plus a new column
Day 13🎵 of advent calendar on sql !! 🎄🎅
12 official days till christmas (yesterday yey):
Santa’s team wants to find the lowest and highest behavior scores recorded this year.
✅ minimum = MIN()
✅ maximum = MAX()
✅ Aggregate functions without `GROUP BY`
✅ Extremes from an entire table
12 official days till christmas (yesterday yey):
Santa’s team wants to find the lowest and highest behavior scores recorded this year.
✅ minimum = MIN()
✅ maximum = MAX()
✅ Aggregate functions without `GROUP BY`
✅ Extremes from an entire table
December 14, 2025 at 5:28 PM
Day 13🎵 of advent calendar on sql !! 🎄🎅
12 official days till christmas (yesterday yey):
Santa’s team wants to find the lowest and highest behavior scores recorded this year.
✅ minimum = MIN()
✅ maximum = MAX()
✅ Aggregate functions without `GROUP BY`
✅ Extremes from an entire table
12 official days till christmas (yesterday yey):
Santa’s team wants to find the lowest and highest behavior scores recorded this year.
✅ minimum = MIN()
✅ maximum = MAX()
✅ Aggregate functions without `GROUP BY`
✅ Extremes from an entire table
Day 12🎵 of advent calendar on sql !! 🎄🎅
12 like the song, today we'll identify each day’s most active user(s):
✅ Count messages per user per day.
✅ Find the day’s most active users.
✅ Use a correlated subquery to compare daily counts.
✅ Use HAVING with MAX() to return all top users, even in ties.
12 like the song, today we'll identify each day’s most active user(s):
✅ Count messages per user per day.
✅ Find the day’s most active users.
✅ Use a correlated subquery to compare daily counts.
✅ Use HAVING with MAX() to return all top users, even in ties.
December 12, 2025 at 7:45 PM
Day 12🎵 of advent calendar on sql !! 🎄🎅
12 like the song, today we'll identify each day’s most active user(s):
✅ Count messages per user per day.
✅ Find the day’s most active users.
✅ Use a correlated subquery to compare daily counts.
✅ Use HAVING with MAX() to return all top users, even in ties.
12 like the song, today we'll identify each day’s most active user(s):
✅ Count messages per user per day.
✅ Find the day’s most active users.
✅ Use a correlated subquery to compare daily counts.
✅ Use HAVING with MAX() to return all top users, even in ties.
Day 11 of advent calendar on sql !! 🎄🎅
Creating all tinsel light color pairs and add a column joining both names with a dash.
✅ Text filtering (case-insensitive searching)
✅ Data cleaning (normalizing text fields)
✅ String manipulation en SQL
SELECT + WHERE + column transformation
Creating all tinsel light color pairs and add a column joining both names with a dash.
✅ Text filtering (case-insensitive searching)
✅ Data cleaning (normalizing text fields)
✅ String manipulation en SQL
SELECT + WHERE + column transformation
December 12, 2025 at 2:39 AM
Day 11 of advent calendar on sql !! 🎄🎅
Creating all tinsel light color pairs and add a column joining both names with a dash.
✅ Text filtering (case-insensitive searching)
✅ Data cleaning (normalizing text fields)
✅ String manipulation en SQL
SELECT + WHERE + column transformation
Creating all tinsel light color pairs and add a column joining both names with a dash.
✅ Text filtering (case-insensitive searching)
✅ Data cleaning (normalizing text fields)
✅ String manipulation en SQL
SELECT + WHERE + column transformation
Day 10 of advent calendar on sql !! 🎄🎅
We calculate the average baking time for each oven and round the result to one decimal place.
+ TIPS to ask the AI support!! Nos vemos ;)
We calculate the average baking time for each oven and round the result to one decimal place.
+ TIPS to ask the AI support!! Nos vemos ;)
December 10, 2025 at 8:51 PM
Day 10 of advent calendar on sql !! 🎄🎅
We calculate the average baking time for each oven and round the result to one decimal place.
+ TIPS to ask the AI support!! Nos vemos ;)
We calculate the average baking time for each oven and round the result to one decimal place.
+ TIPS to ask the AI support!! Nos vemos ;)
Day 9 of advent calendar on sql !! 🎄🎅
The elves are testing new tinsel light combinations to find the next big holiday trend. Here we are generating every possible pairing of tinsel colors and light colors and include in our output a column that combines the two values separated with a dash ‘-’.
The elves are testing new tinsel light combinations to find the next big holiday trend. Here we are generating every possible pairing of tinsel colors and light colors and include in our output a column that combines the two values separated with a dash ‘-’.
December 9, 2025 at 4:51 PM
Day 9 of advent calendar on sql !! 🎄🎅
The elves are testing new tinsel light combinations to find the next big holiday trend. Here we are generating every possible pairing of tinsel colors and light colors and include in our output a column that combines the two values separated with a dash ‘-’.
The elves are testing new tinsel light combinations to find the next big holiday trend. Here we are generating every possible pairing of tinsel colors and light colors and include in our output a column that combines the two values separated with a dash ‘-’.
Day 8 of advent calendar on sql !! 🎄🎅
Mrs. Claus is organizing the holiday storage room and wants a single combined list of all decorations. Both Christmas trees and light sets.
Finally, storage 🫙
Mrs. Claus is organizing the holiday storage room and wants a single combined list of all decorations. Both Christmas trees and light sets.
Finally, storage 🫙
December 9, 2025 at 1:27 AM
Day 8 of advent calendar on sql !! 🎄🎅
Mrs. Claus is organizing the holiday storage room and wants a single combined list of all decorations. Both Christmas trees and light sets.
Finally, storage 🫙
Mrs. Claus is organizing the holiday storage room and wants a single combined list of all decorations. Both Christmas trees and light sets.
Finally, storage 🫙
Day 7 of advent calendar on sql !! 🎄🎅
How many unique snowflake types were recorded on the December 24th, 2025.
How many unique snowflake types were recorded on the December 24th, 2025.
December 8, 2025 at 3:59 AM
Day 7 of advent calendar on sql !! 🎄🎅
How many unique snowflake types were recorded on the December 24th, 2025.
How many unique snowflake types were recorded on the December 24th, 2025.
Day 6 of advent calendar on sql !! 🎄🎅
Calculating the annual snowfall for each resort and dividing them into quartiles (four groups) based on their snowfall levels.
PD.I've got some issues yesterday with sending by phone, I had to do it and edit it today, but here we are!
Calculating the annual snowfall for each resort and dividing them into quartiles (four groups) based on their snowfall levels.
PD.I've got some issues yesterday with sending by phone, I had to do it and edit it today, but here we are!
December 7, 2025 at 9:46 PM
Day 6 of advent calendar on sql !! 🎄🎅
Calculating the annual snowfall for each resort and dividing them into quartiles (four groups) based on their snowfall levels.
PD.I've got some issues yesterday with sending by phone, I had to do it and edit it today, but here we are!
Calculating the annual snowfall for each resort and dividing them into quartiles (four groups) based on their snowfall levels.
PD.I've got some issues yesterday with sending by phone, I had to do it and edit it today, but here we are!
Day 5 of advent calendar on sql !! 🎄🎅
You are doing great!! You can do it!!
You are doing great!! You can do it!!
December 5, 2025 at 9:26 PM
Day 5 of advent calendar on sql !! 🎄🎅
You are doing great!! You can do it!!
You are doing great!! You can do it!!
Day 4 of advent calendar on sql !! 🎄🎅
Narrative skills, enjoy!!
Narrative skills, enjoy!!
December 4, 2025 at 7:22 PM
Day 4 of advent calendar on sql !! 🎄🎅
Narrative skills, enjoy!!
Narrative skills, enjoy!!
Day 3 of advent calendar on sql !! 🎄🎅
-Day 3 of advent calendar on sql
-Day 3 of advent calendar on sql
December 4, 2025 at 3:33 AM
Day 3 of advent calendar on sql !! 🎄🎅
-Day 3 of advent calendar on sql
-Day 3 of advent calendar on sql
Day 2 of advent calendar on sql !! 🎄🎅
(edit skills +1!)
(edit skills +1!)
December 3, 2025 at 12:06 AM
Day 2 of advent calendar on sql !! 🎄🎅
(edit skills +1!)
(edit skills +1!)
Day 1 of advent calendar on sq l!! 🎄🎅
December 2, 2025 at 12:55 AM
Day 1 of advent calendar on sq l!! 🎄🎅
Monday
-- Day one of POSTGRESQL
Database normalization helps reduce redundancy by splitting large tables into smaller ones and organizing data logically.
-1NF ensures atomic values
-2NF removes partial dependencies
-3NF eliminates transitive dependencies to keep data clean and consistent
Dynamic!
-- Day one of POSTGRESQL
Database normalization helps reduce redundancy by splitting large tables into smaller ones and organizing data logically.
-1NF ensures atomic values
-2NF removes partial dependencies
-3NF eliminates transitive dependencies to keep data clean and consistent
Dynamic!
November 25, 2025 at 3:03 AM
Monday
-- Day one of POSTGRESQL
Database normalization helps reduce redundancy by splitting large tables into smaller ones and organizing data logically.
-1NF ensures atomic values
-2NF removes partial dependencies
-3NF eliminates transitive dependencies to keep data clean and consistent
Dynamic!
-- Day one of POSTGRESQL
Database normalization helps reduce redundancy by splitting large tables into smaller ones and organizing data logically.
-1NF ensures atomic values
-2NF removes partial dependencies
-3NF eliminates transitive dependencies to keep data clean and consistent
Dynamic!
Thursday of MySQL
-- Stored procedure for inserting randomly generated records
-- Stored procedure for inserting randomly generated records
November 21, 2025 at 3:01 AM
Thursday of MySQL
-- Stored procedure for inserting randomly generated records
-- Stored procedure for inserting randomly generated records
Where does mission zine come from? :
Rights deserved here
Rights deserved here
November 19, 2025 at 9:30 PM
Where does mission zine come from? :
Rights deserved here
Rights deserved here