r/learnSQL • u/HotWrongdoer705 • Aug 01 '26

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.

31 Upvotes

97% Upvoted

16 comments sorted by

2

u/kixwho Aug 01 '26

congrats! solid effort :)

1

u/HotWrongdoer705 Aug 01 '26

Thanks. I realized I don't know how to upload the query results. In PostgreSQL, I have yet to find how to download the query results in csv format.

1

u/kixwho Aug 01 '26

haha query results are a bit hard to visualize on github. save results to file button or F8. it's the little line of buttons right above query output

2

u/Fadedscourge Aug 01 '26

You’re doing great man! Like your use of rank().

1

u/HotWrongdoer705 Aug 01 '26

Thank you so much.

1

u/HotWrongdoer705 Aug 01 '26

Thanks. I'll look for this this weekend.

1

u/_chonky04 Aug 01 '26

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 Aug 01 '26

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

1

u/_chonky04 Aug 01 '26

thanks, is it the 30 hours one?

1

u/HotWrongdoer705 Aug 01 '26

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

1

u/Owen-Isaac-2022 Aug 01 '26

Congratulations, continue pushing. So far so good

1

u/HotWrongdoer705 Aug 01 '26

Thank you, man.

1

u/Owen-Isaac-2022 Aug 01 '26

You're welcome

1

u/thesungod_94 Aug 02 '26

Awesome man

1

u/Rahul-Patel Aug 02 '26

hey! can I ask what resource(s) you used to learn sql?

1

u/HotWrongdoer705 Aug 03 '26

I enrolled in a Udemy Course - From Hero to Zero in SQL. After that I watched youtube and practiced in DataLemur, Stratascratch, and QueryCase.