TwitterFacebook

Art Of Code

Software and Data Science

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.
Christian Páez
Christian Páez
4 min read
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.
Christian Páez
Christian Páez
1 min read
sql, writeups, hackerrank

HackerRank SQL Preparation: Weather Observation Station 1(MySQL)

Query a list of CITY and STATE from the STATION table.
Christian Páez
Christian Páez
1 min read
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.
Christian Páez
Christian Páez
1 min read
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.
Christian Páez
Christian Páez
1 min read
sql, writeups, hackerrank

HackerRank SQL Preparation: Select by ID(MySQL)

Query all columns for a city in the CITY table with the ID 1661.
Christian Páez
Christian Páez
1 min read
sql, writeups, hackerrank

HackerRank SQL Preparation: Select All(MySQL)

Query all columns (attributes) for every row in the CITY table.
Christian Páez
Christian Páez
1 min read
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.
Christian Páez
Christian Páez
1 min read
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.
Christian Páez
Christian Páez
2 min read
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.
Christian Páez
Christian Páez
2 min read
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
Christian Páez
Christian Páez
1 min read
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.
Christian Páez
Christian Páez
1 min read