Providing you with Digital Support

I love to write about digital things, snoop around in code and learn about new technologies. If you have a suggestion for me, consider emailing me or filling out the contact form below. If you have questions about anything digital or need some help – reach out, or email me at william@yourdigitalaid.com 

William C's avatar

Hackerrank – Draw the Triangle 2 – SQL – Solution

A slightly more difficult solution, Hackerrank draws on it’s previous question in of Draw the Triangle 1, with Draw the Triangle 2. Let’s jump into it. The problem P(R) represents a pattern drawn by Julia in R rows. The following pattern represents P(5): Write a query to print the... Continue Reading

William C's avatar

Hackerrank – SQL – Aggregate – Top Earners Solution

Here’s a quick an easy SQL Hackerrank solution for one of the last “aggregate” courses. It’s an interesting one because you can end up overthinking your approach. The problem We define an employee’s total earnings to be their monthly salary x months  worked, and the maximum total earnings to be... Continue Reading

One part agile, another part digital – all parts passion.

YourDigitalAid is a collection of all things digital, real world and whatever else I wanted to write about. I’m a product-person by day and a scrappy digital-technepreneur by night. As you probably know, everything here is an anecdote, but being a good data driven individual, I will try to back up everything I do with results.

Get in touch

If you happen to need agile, product, digital marketing or process management support, shoot me an email, fill out a contact form or comment in one of my many posts / articles for help, guidance and support.