The day-to-day things I learn as a software engineer

How to Group By Alias in an AWS Athena SQL Query

Nov 24, 2022

SQL

How to Group Rows Into Buckets with Count in a SQL Query

Nov 11, 2022

SQL

How to Get the Average String Length of a Column in MySQL

Sep 3, 2022

SQL

How to Check If Value Exists in a MySQL Table

Aug 11, 2022

SQL

How to Query a Table Using MySQL CLI

Aug 9, 2022

SQL

How to Get All Keys in JSON Object from MySQL

Jul 23, 2022

SQL

How to Query JSON Objects in MySQL

Jul 22, 2022

SQL

How to Match Columns that Contain a Substring in SQL

Jul 20, 2022

SQL

How to Set Up a Free PostgreSQL Database on Heroku

Feb 1, 2022

SQL

How to Change the Primary Key to Another Column in SQL Server

Jan 20, 2022

SQL

How to Modify Table to Use Composite Primary Key in MySQL

Oct 14, 2021

SQL

How to Format a Number with Two Decimal Places in SQLite

Sep 22, 2021

SQL