top of page


Python Word Order - Another Hacker Rank Solution
Consider the following problem. You are given a number of words to read into your python program. The output needs to have on the first...
Aug 29, 20252 min read


Capitalize! With Hacker Rank
Another Python problem from Hacker Rank. Given an unseen string of a person's name can you capitalise the correct letters? You are asked...
Aug 25, 20251 min read


HackerRank - The Minion Game Solution
Kevin and Stuart want to play the ' The Minion Game '. Game Rules Both players are given the same string, Both players have to make...
Apr 27, 20252 min read


Calculating the probability of the number of tries scored in an NRL game using the Poisson Distribution
In the NRL one of the many markets that are capable of being framed is how many tries each team will score in a game. Utilising the...
Apr 25, 202513 min read


Swap Case in Python - Hacker Rank Challenge to Write a Function that swaps the case of all letters in a string
Suppose you were given a string that was equal to: Hello - Welcome To The Python Community but you needed it to return: hELLO - wELCOME...
Apr 23, 20251 min read


Introductory Python HackerRank - Write a Function that determines if a year is a leap year
The Hacker Rank problem is phrased in the following way: An extra day is added to the calendar almost every four years as February 29,...
Apr 22, 20252 min read


Python HackerRank! Find the Runner-Up Score - AKA Finding the second largest number in an array, list or tuple.
Given the participants' score sheet for your University Sports Day, you are required to find the runner-up score. You are given scores....
Apr 18, 20251 min read


Stuck on the Hard Rated SQL Hackerrank Problems? Never Fear, Code Walkthrough for the Advanced Join is below.
Samantha interviews many candidates from different colleges using coding challenges and contests. Write a query to print the contest_id,...
Apr 18, 20251 min read


Calculating the Median in SQL Server - Consider This Hacker Rank Problem
A median is defined as a number separating the higher half of a data set from the lower half. Query the median of the Northern Latitudes...
Feb 22, 20251 min read


Hackerrank - Calculating Leaf, Inner and Root Nodes in a Tree with SQL
Binary Trees make up a large part of computer science, but in this case, it is a simple SQL question asked by our friends at hackerrank....
Feb 20, 20252 min read


Factorial Digit Sum - Project Euler #20
Consider the number 100! That is the product of all of the numbers between 1 and 100. That is to say, 1 x 2 x 3 ... x100. Project Euler has tasked us with providing the sum of the digits of that number. The first thing to do is to use the math library and the factorial function to generate the number. Following that we need to initialise a list and write each individual digit as a member of the list. Then, we just wrap that in a sum(list) and the print the answer out. Quite a
Jan 9, 20251 min read


Ever wondered if your password is strong enough? Consider this password strength checker written in python!
Consider the password: terry Seems weak, but how do we know? Running the code at the bottom of the page - if we input the term terry we...
Jan 3, 20251 min read


Project Euler Problems 1 & 2: Multiples of 3 and 5 //Even Fibonacci Numbers
Project Euler is a series of mathematical questions that need the accompaniment of computer programming to solve. It is permissible to share the solution to the first 100 questions but none thereafter. The first question asks for the sum of the numbers which are divisible by 3 or 5 under 1000. The code solution is here (in python): list_x = list(range(1,1000)) list_new = [] #print(list_x) for integer in list_x: if integer % 5 == 0 or integer % 3 == 0: list_new.append(inte
Jan 1, 20251 min read


Identifying the only human readable file in a Linux folder - Over the wire Bandit level 4 - 5 password revealed
The over the wire Capture the Flag games are a great way to sharpen your command line linux skills. To obtain the password to level 5 the...
Dec 27, 20241 min read


Date Chaos – Creating a viable date dimension table from any table that you have in the database
Would you like to know how many Tuesdays are in 2024 and 2025 using a random table from the Adventureworks Database? No? Me neither. But...
Jul 31, 20241 min read


No ERD?! No worries! Deriving the output code of a report table from the Information Schema
We’ve all been there. You turn up to work and your manager says you need to generate some reports from so-and-sos database. Cool, no...
Jun 30, 20241 min read


The Difference Between an INNER JOIN and a CROSS APPLY
Friday night football, Wests Tigers are in front and your wife reminds you that you are going to see the in-laws. Sometimes it’s...
Jun 21, 20241 min read


Writing messages in spatial data in SQL? Is this possible? Yes! Is it worth it? No
Are you sick of writing cards for your spouse on a special occasion? Would you like to do something a little more meaningful? If you...
Jun 18, 20241 min read


Capture the Flag – SQL Style
Capture the Flag is native to the area of cybersecurity. The thrill of writing the correct linux command to retrieve the password in CTF...
Jun 14, 20242 min read


Don’t Make DeDuplicating Dastardly Difficult – A devious demystification of the dreaded duplicate
Hey Lucas, Yes boss? Can you tell me which tables have duplicates in the Sales schema in the Adventures Works database by lunchtime? But...
Jun 11, 20241 min read
bottom of page