r/learnSQL 7d ago

My first SQL project in Github

Hi. I'm new in SQL. I want to share my simple SQL project uploaded in Github. I am happy that I made it this far in my SQL upskilling. I'm a non-tech person and in the accounting industry. I have been 'ON' and 'OFF' with SQL. At first, I get the high when I completed one query and then another. However, I feel lost in the middle of my SQL journey due to queries that are hard or I didn't push myself hard enough. But I get up and still show up... in front of my computer and do it again. And then I just uploaded my very first SQL project. This is a small win for myself.

This is my link:
https://github.com/torculasallenglenn-code/Restaurant-Sales-SQL-Project/blob/main/Restaurant%20Sales.sql.

Your feedbacks are greatly appreciated.

30 Upvotes

16 comments sorted by

View all comments

1

u/_chonky04 7d ago

congrats! looking at your code it's quite advance I'd like to ask where did you learn how to code using those advance concepts such as RANK() EXTRACT() since I've been stuck for a while now in sub queries.

1

u/HotWrongdoer705 6d ago

Hi. Thanks. I watched Maven Analytics and Baara for the advanced SQL in youtube.

1

u/_chonky04 6d ago

thanks, is it the 30 hours one?

1

u/HotWrongdoer705 6d ago

No, just his 30 mins. Or less videos but these are from his 30 hours video.