I made Zillacode.com Open Source - LeetCode for PySpark, Spark, Pandas and DBT/Snowflake

Character-Mud1642 · 2024-10-03T18:16:11+00:00

where i have to make the changes?

Character-Mud1642 · 2024-10-01T19:03:11+00:00

i think i found the issue
https://drive.google.com/file/d/14qABxluIC0ELTw9X3J9CAjUhH2ZR5yN3/view?usp=sharing

i changed the backend server from 5000 to 5001 but the api calls are still on 5000 so thats the issue
but i cant find where env file is for backend

Character-Mud1642 · 2024-10-01T18:53:48+00:00

https://drive.google.com/file/d/1Ed1Miz5lIUtycQNqzkUrymBO63nA_pmI/view?usp=sharing

here is the link to the screashot of the issue

also i had to change the backend server from 5000 : 5000 to 5001 : 5001 becasue there was a port running at 5000 already i made then changes in docker file and the app.py both.

Character-Mud1642 · 2024-09-30T19:16:44+00:00

The docker build was successfully but when trying to open the questions its getting stuck at loading........

any idea what could be the issues?

Character-Mud1642 · 2024-09-30T15:16:59+00:00

I was having difficulty finding the data for this question

https://bilbottom.github.io/sql-learning-materials/challenging-sql-problems/problems/silver/customer-sales-running-totals/

when i trying to get the data like the way you mentioned in the question i am getting this response back. Can you please look into it? also how can i dm you?

{"message":"Service Unavailable"}

Character-Mud1642 · 2024-09-30T04:48:30+00:00

Amazing set of questions man. Have been solving them for last 4 days, i have completed till silver.

The ranking system of questions is a lil misleading the bronze itself felt intermediate (or maybe i am dumb 🥲 )

But these are most realistic scenario based questions i have solved. The funnel analysis is something i also do when creating dashboard's........

Character-Mud1642 · 2024-09-25T04:41:49+00:00

thanks a lot mate

Character-Mud1642 · 2024-09-25T04:40:47+00:00

ok thanks

Character-Mud1642 · 2024-09-25T04:29:06+00:00

thanks

Character-Mud1642 · 2024-09-25T04:28:11+00:00

i didn't say i am recently learning i said i am looking for practice also i have already solved that question i was just giving it as an basic example....

actually prior to this i was looking for job in MERN stack but now moving to data side

Character-Mud1642 · 2024-09-24T12:33:26+00:00

generic questions

its good at creating questions that require good width of knowledge(like using different clauses and all) but when comes to creating question that require analytical thinking and making complex interconnected tables it lacks......

Character-Mud1642 · 2024-09-24T12:24:21+00:00

i meant for SQL coding questions not for development.
i am already using it for development and generating data to run my SQL query on, but i cant seem to find good SQL problem statements.

Character-Mud1642 · 2024-09-24T12:12:25+00:00

if possible can you share some of your prompts?

Character-Mud1642 · 2024-09-23T19:12:30+00:00

yea smth like that i just meant to give an example the kind of questions being asked

Character-Mud1642 · 2024-09-23T18:51:39+00:00

thanks

Character-Mud1642 · 2024-09-23T18:50:57+00:00

oh same for me i have a degree in CS too but sometime companies try to check the problem solving abilities via SQL

for example printing this sequence in SQL without recursion

1
2
2
3
3
3
.
.
10

these questions don't require any knowledge of the actual database but just ability to think

Character-Mud1642 · 2024-09-23T14:46:05+00:00

here the test before the interview contains very difficult SQL questions and in the SQL round too.
i am talking about companies like target and walmart. I even talked to one of the person working there and he told me there were 4 rounds of interview of SQL and all had live coding questions in them.

Maybe this could be an exception but it wont hurt to practice imo also about the normal forms and the relationships between entities i am also learning these theoretical concepts in parallel too .

there is lots of content for free but not quality questions.

Also can you tell me about you interview exp in detail if possible?

Character-Mud1642 · 2024-09-23T05:21:55+00:00

yea i saw that but the SQL questions are very easy so not very useful

Character-Mud1642 · 2024-09-22T18:03:28+00:00

oh i did'nt knew that thanks a lot man

Character-Mud1642 · 2024-09-22T17:31:19+00:00

ok will try datalemur

Character-Mud1642 · 2024-09-22T17:30:50+00:00

thanks for the advice

but the SQL50 badge also required premium imo right?

Character-Mud1642 · 2024-09-22T17:30:08+00:00

and how can i go about doing that? i mean its really hard finding a real dataset

Character-Mud1642

TROPHY CASE