Christian Páez - Art Of Code

sql, cheatsheet

The Ultimate SQL JOIN Cheat Sheet

If you're working with relational databases, you'll often need to combine data from multiple tables. SQL JOINs help you achieve this.

sql, hackerrank, writeups

Featured

HackerRank SQL Preparation: Weather Observation Station 3(MySQL)

Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer.

sql, writeups, hackerrank

HackerRank SQL Preparation: Weather Observation Station 1(MySQL)

Query a list of CITY and STATE from the STATION table.

sql, writeups, hackerrank

HackerRank SQL Preparation: Japanese Cities' Names(MySQL)

Query the names of all Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.

sql, writeups, hackerrank

HackerRank SQL Preparation: Japanese Cities' Attributes(MySQL)

Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.

sql, writeups, hackerrank

HackerRank SQL Preparation: Select by ID(MySQL)

Query all columns for a city in the CITY table with the ID 1661.

sql, writeups, hackerrank

HackerRank SQL Preparation: Select All(MySQL)

Query all columns (attributes) for every row in the CITY table.

blog, linux, scripting

Automate binary execution at Startup with BASH

Automating the startup of frequently used binaries can save time and streamline your workflow. This blog post introduces a simple Bash script that adds specified binaries to a function that executes them every time you start your computer.

blog, linux, path, scripting

Simplifying PATH Management with Bash

In this blog post, we create a simple script that streamlines the process of adding directories to your PATH, with instructions on how to use it with curl.

blog, automation, software, scripting

Automating Video editing with programming knowledge

Many video editing tasks can be repetitive when applied frequently across different videos. In this blog post, we'll explore how to enhance videos by adding opacity transitions using Python and OpenCV.

sql, hackerrank, writeups

HackerRank SQL preparation; Revising the Select Query II(MySQL)

Query the NAME field for American cities in the CITY table with populations larger than 120,000. The CountryCode for America is USA

writeups, sql, hackerrank

HackerRank SQL Preparation: Revising the Select Query I(MySQL)

Query all columns for American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.