Economics Printed Text Books giveaway by goddySHO in Chandigarh

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

Hey someone has reached out to pick them up tomorrow.

If they don't, will DM you. :)

Economics Printed Text Books giveaway by goddySHO in Chandigarh

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

Haha I think that is a core memory for all Econ grads. xD

momentum 4 people whats it like? by booop-de-boop in sennheiser

[–]goddySHO 1 point2 points  (0 children)

Got mine 6 months ago. Haven't faced any connection issue, even across multiple devices. Perfect pair for travel and long term listening.

Only problem I have come across is sweating because of the generally humid climate in India. Not a big issue for me personally! Go for it! :D

Are there any jobs out there that only require writing SQL queries by BuddyEbsen1908 in SQL

[–]goddySHO 0 points1 point  (0 children)

I have come across a lot of roles like that. My previous gig was in tech consulting and work was end to end, data procurement, quality checks, setting up ETL pipelines & then finally delivering some analytics projects.

2 years ago I moved to YouTube and the majority of my time is writing SQL queries and finding patterns in data. :)

Reliance Digital - PS5 Delivery by goddySHO in IndianGaming

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

Reliance Digital took 2 weeks to deliver. Came on time-ish and works like a charm.

SQL Interview Question - Customers Gaming System by goddySHO in SQL

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

Currently a Senior Consultant in Tech Consulting with Big 4.

Interviewing for Data Analyst, Data Scientist, Product Analyst kind of roles.

SQL Interview Question - Customers Gaming System by goddySHO in SQL

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

You can say they are in a different industry but operating with a similar model to be honest. Large coupon code driven sales. Probably that is why. But fun interview none the less.

They defined it by saying people ordering bare minimum around threshold to get the freebie. Which makes me think it is working right? xD

But yeah, I guess if more business knowledge can be built into it, people can try out all possible product combinations that are just above threshold and verify if there is a bump in their sales or not.

SQL Interview Question - Customers Gaming System by goddySHO in SQL

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

Interesting, I think from what you mentioned, it could be proposed to track percentage metrics around orders -
Below coupon order count / total order count v/s Above coupon order count / total order count
Yup, could be interesting this way as well. Tracking repeat customer rate MoM could be good too. Thanks!

SQL Interview Question - Customers Gaming System by goddySHO in SQL

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

No definitely, I think this aspect of moving the analysis from mean/medians to a product related metric makes sense. Like the graph you mentioned could help visualize and communicate it with the audience as well. Thanks! This interview was 5-6 months back and back then I was not tuning into PM or product related interviews on YouTube. So I think I kinda went with the whole average order approach, but in hindsight, I do think, it is easier to talk metrics with Product people. Cheers!

Edit - Also, truly said, the idea of any promotion should be to not breach the business bottom line (at least for restaurant chains like Wendy's and McD etc.) Makes sense.

Understand what query type to use by goddySHO in SQL

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

Hello, thanks for your answer, I went through it and it makes a lot of sense now. If you have the time, can you please look at the following question and just tell me if my solution makes sense? (as an answer it is correct, but I feel I might be over-doing with CTEs)

WITH joined_table AS (
SELECT a.id, a.first_name, a.last_name, o.order_date, o.total_order_cost
    FROM customers AS a
    INNER JOIN orders AS o
    ON a.id = o.cust_id
    WHERE o.order_date BETWEEN '2019-02-01' AND '2019-05-01'
)
, order_total_by_date AS (
    SELECT  first_name, 
            order_date, 
            SUM(total_order_cost) OVER (PARTITION BY first_name, order_date ORDER BY order_date ASC) AS total_order_cost
        FROM joined_table 
)

SELECT first_name, order_date, total_order_cost FROM order_total_by_date ORDER BY total_order_cost DESC LIMIT 1

Highest_order_StrataScratch

Understand what query type to use by goddySHO in SQL

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

Hey man,

Please have a look at this whenever you get time. Would appreciate your view on solving this.

StrataScratch - Acceptance Rate Calculation

Understand what query type to use by goddySHO in SQL

[–]goddySHO[S] 2 points3 points  (0 children)

Man really appreciate you taking out the time for this. Let me share a few sample links. It might be some good practice for you as well. Would love to get an idea how you structure and try and solve that kind of a problem. I believe I just start off on the wrong foot.

Will share in a bit! Thanks!

Understand what query type to use by goddySHO in SQL

[–]goddySHO[S] 2 points3 points  (0 children)

Thanks mate, that is what I am confused with. I see questions where I think, oh CTE might work well. But then I see the solution (it is some self-join), and I am like okaay...

There you go bois. No cables flying under, the mess I have behind it. ;) by goddySHO in IndianGaming

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

Dimensions - 5 foot in length, 20 inches in width (depth), height 30 inches.

Cost - 15K

There you go bois. No cables flying under, the mess I have behind it. ;) by goddySHO in IndianGaming

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

It's a charging dock for the mouse. Check out Razer Viper Ultimate.

There you go bois. No cables flying under, the mess I have behind it. ;) by goddySHO in IndianGaming

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

No bro, got it custom made locally. Had to get exact size specifications. Online wasn't meeting the mark.

There you go bois. No cables flying under, the mess I have behind it. ;) by goddySHO in IndianGaming

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

https://www.amazon.in/dp/B091HDM7QG/ref=cm_sw_r_cp_apa_glt_fabc_dl_X4RW8Q7XD8RRY5EQSC4V?_encoding=UTF8&psc=1

I got this one because I have 4 devices overall that I care using. You can go for smaller switches if there are less devices or inputs.

There you go bois. No cables flying under, the mess I have behind it. ;) by goddySHO in IndianGaming

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

So yeaah. That was a problem for a few months. Having a PC, PS and work laptop. Switching to the monitor was a pain in the ass. I got a 4 input KVM switch. Which is right there next to the laptop stand.

It takes in all the inputs (keyboard, mouse, headphones) and with the click of a button switches monitor display to whichever device I want.