#  chr3st5an

Hello, internet Stranger! My name is Christian, and I am currently a student at the University of Duisburg-Essen, studying Software Engineering and tutoring students in the subjects Modelle der Informatik and Datenbankmanagementsysteme. My main interests are in the field of theoretical computer science, especially in Automata Theory and Formal Languages.

##   Socials

You'll probably find me on the following platforms:

• Discord
• Instagram
• GitHub
• Telegram

##   Music

Here are some nice songs I have listened to recently:

• Skydiver - Neon
• Ruin The Night - Fitz and The Tantrums
• Dolce Vita - Ryan Paris
• Fly Me To The Moon - Astrophysics
• Maniac - Carpenter Brut (really addictive)
• When the Rain Begins to Fall - Jermaine Jackson
• I Give You a Rendez-Vous - Patrick Hernandez

If you liked these, you should probably follow me on Spotify.

##   Projects

I think this section will stay empty for a while since I am busy with other things. But an honorable mention would be my bachelor project, which was about implementing a maze solver for the Turtlebot3.

##   SQL Mystery

During the past years, I have done too many SQL queries... hence I have become a bit insane. (Average SQL Experience)

So, ... let's talk if you understand the following PostgreSQL query :)

>>> SELECT lastname("#")
...      , COUNT(DISTINCT (SELECT COUNT(NULL) FROM characters))
...      , RANK('Christian') WITHIN GROUP (ORDER BY firstname ASC)
...   FROM characters "#"(id, firstname, lastname)
...  GROUP BY ALL 1, firstname ^@ 'A'
... WINDOW w AS (PARTITION BY lastname ORDER BY COUNT(*) DESC)
...  ORDER BY RANK() OVER w <> 1
...  FETCH FIRST ROWS WITH TIES;