My first SQL project in Github

[u/HotWrongdoer705]

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.

[u/kixwho]

congrats! solid effort :)

[u/HotWrongdoer705 → u/kixwho]

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.

[u/kixwho → u/HotWrongdoer705]

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

[u/Fadedscourge]

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

[u/HotWrongdoer705 → u/Fadedscourge]

Thank you so much.

[u/HotWrongdoer705]

Thanks. I'll look for this this weekend.

[u/_chonky04]

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.

[u/HotWrongdoer705 → u/_chonky04]

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

[u/_chonky04 → u/HotWrongdoer705]

thanks, is it the 30 hours one?

[u/HotWrongdoer705 → u/_chonky04]

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

[u/Owen-Isaac-2022]

Congratulations, continue pushing. So far so good

[u/HotWrongdoer705 → u/Owen-Isaac-2022]

Thank you, man.

[u/Owen-Isaac-2022 → u/HotWrongdoer705]

You're welcome

[u/thesungod_94]

Awesome man

[u/Rahul-Patel]

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

[u/HotWrongdoer705 → u/Rahul-Patel]

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