Art Of Code
Software and Data Science
Home
Projects
Author
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.
Page 1 of 5
Next