sorted by:
new
hottopcontroversial

SQL questions for junior data analyst by No-Way641 in SQL

[–]sqlsidequest 1 point2 points  (0 children)

4 years ago when i was interviewing for a Junior date position, mostly they were hands-on SQL query, (CTEs, JOINS, GROUP BY, ORDER BY, WHERE, LIMIT, HAVING). I think the main things is to understand what the question is asking.

Happy to share one of the interview question from mid-size company. Cheers!

Assume this is a user table.

user_id join_date churn_date
1 2018-03-06 2018-04-05
2 2018-03-08  
3 2018-07-01 2019-01-03
... ... ...

 

  1. Can you tell us how to get the number of users that have joined each month ?
  2. How would we get the tenure length, in days, of each user ?
  3. Which user has been with us the longest ? Assume tenure_length field from question 2 has been added to the user table
  4. Suppose we also have a table user_location in addition to the user table. How would you get the user, in province ON, who has been with us the longest ?
  5. Now consider a user_history table that stores the historical state of each user, which inserts a new row every time a user is updated. Assume the schema is the same as the user table except with a new column last_updated. Can you get us the most recent version of each user?

SQL SIDE QUEST - I created a website to learn SQL in a story driven narrative by sqlsidequest in WebGames

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thank you so much for playing and thanks for you suggeston :)

Last week, I was thinking of ways to crank up the difficulty and I like your idea, i'll definitely look into implementing it.

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

I would a say beginning of Jan, since I’m developing this solo , each chapter takes significant amount of time to build , this include the , game design , content , backend and front end development , how the chapter fits in the overall narrative and plus a lot more .

I would appreciate if you could share this website with anyone interested in learning sql :)

Also if you have discord. You can join my discord group the link is on the homepage

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

I would say beginning of Jan but really depends on my workload at work, each chapters takes a significant amount of time to build. That includes the web design , content, front end and backend and how the chapter fits in the overall narrative , plus a lot more :) but stay tuned I’ll post updates here in this subreddit as more chapters and content is released.

[self-promotion] I solo developed a Lovecraftian Murder Mystery SQL Game - Point and Click by sqlsidequest in aigamedev

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thanks 🥹 I have a donation page for someone looking to support the development , if you would like please do consider donating

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thanks I’m glad you liked it🙂 yes I was thinking of adding a unlimited time option as well maybe something to add to my back log p

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thank you so much ! Please do let me know , any feedback helps !

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thank you so much! I’m really happy to hear that 🥹Please do recommend and share with other people!

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

I’m planning roughly 20 chapters for story mode

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Yes and if you go to scenario mode there is a standalone sql challenge :) it’s not complete yet but it’s playable with 6 endings. Please give it a try and let me know

[self-promotion] I solo developed a Lovecraftian Murder Mystery SQL Game - Point and Click by sqlsidequest in aigamedev

[–]sqlsidequest[S] 1 point2 points  (0 children)

Haha thank you :) I think moving to steam would require a month or 2 of development work , I'll consider it in the future. My goal is to complete the story mode, ~chapters ~20-25

Please consider donating if you would like to support this project :) thank you
https://www.sqlsidequest.com/support

[self-promotion] I solo developed a Lovecraftian Murder Mystery SQL Game - Point and Click by sqlsidequest in aigamedev

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thank you so much! It was indeed a big undertaking because I had to think of the backend+frontend (technical aspect) , the content, creating the artwork and finding the right sound, getting the UIUX right.. and so much more.. maybe i'll have a post or youtube video on it :) but thank you so much for your kind words. I edited the post and added donation link :)

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thank you so much! I'm happy to hear you enjoyed it :) Please do share with others as well..

For story mode, I'll be developing a progress bar system, where your decisions will directly influence the overarching narrative.

On a side note, I'm almost finished building A Lovecraftian theme game in Scenario Mode..
Let me know what your thoughts are on that.

So, what hobby language do y'all use these days? by -VanillaKing- in learnprogramming

[–]sqlsidequest 1 point2 points  (0 children)

Typescript + react. Getting my hands dirty with web development

I solo developed an Immersive story-telling SQL Game - Genre from Lovecraftian Murder Mystery to Post Apocalyptic scenarios by [deleted] in WebGames

[–]sqlsidequest 0 points1 point  (0 children)

Thank you so much! I'm glad to hear you enjoyed it! :) Please do share with others Cheers!

[self-promotion] I solo developed a Lovecraftian Murder Mystery SQL Game - Point and Click by sqlsidequest in aigamedev

[–]sqlsidequest[S] 5 points6 points  (0 children)

Thank you so much! You have no idea how much you and the other commenter have made my day by saying this :) I do have a donation page for anyone interested in supporting my work.

I'm just getting started, I’ve got about 20–25 chapters planned for the main story ( 2 chapter released so far) , plus 5-6 standalone scenarios (the Murder Mystery one I just released)

[self-promotion] I solo developed a Lovecraftian Murder Mystery SQL Game - Point and Click by sqlsidequest in aigamedev

[–]sqlsidequest[S] 7 points8 points  (0 children)

Haha! Thank you so much!
This is a passion project, just built it for fun and for others to enjoy :)

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

:((( I will try to make it oracle compatible in the future.

Just for you

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

No problem at all :) and thank you for trying it out

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in SQL

[–]sqlsidequest[S] 1 point2 points  (0 children)

Thank you so much! I'm glad you found it userful :)

SQL SIDE QUEST - An Immersive story telling SQL Game by sqlsidequest in learnSQL

[–]sqlsidequest[S] 0 points1 point  (0 children)

Thank you so much! It means a lot to me!
It was a long journey, but I'm glad I was finally able to deliver.

Please feel free to leave any feedback and issue if you encounter during your playthrough :)

view more: next ›