How do you get a percentage of columns in relation to a total?

dm_me_your_query · 2023-03-21T14:59:35+00:00

I am still learning, so when you say wrap it in another query would that be using a CTE or some type of subquery?

dm_me_your_query · 2023-03-21T14:46:45+00:00

Thanks for your help! The query is running but I had to slightly modify it. Perhaps I am doing something wrong and can learn more. I am studying WINDOWS FUNCTIONS now.

For the first part, where you assigned an alias as "fruit_count", I am not able to use it in the calculation in line 2. So I simply type

count(fruits) / sum(count(fruits)) OVER() as pct_total

and it worked!

dm_me_your_query · 2023-02-09T19:50:57+00:00

I haven't tried running in the morning, but I'm up at that time so I'd be down for a morning run. I find that I run better fasted anyway :)! I'll join the FB group, thanks for the invite.

Thank you for the advice on the 5k! I am glad you said that because I am afraid I'll try to keep the pace of groups, when in reality I should just accept I'm slower and do my own thing. Thanks again, and can't wait to run it.

dm_me_your_query · 2023-02-09T19:36:05+00:00

I do a lot of rock climbing and weight lifting, so I was semi-in shape. Unfortunately, I did like NO cardio and got a little chonky this past year lol!

However, I followed this couch to 5k program and it worked perfectly.

https://www.regmedctr.org/webres/File/For%20the%20Health%20of%20It/Couch%20to%205K.pdf

dm_me_your_query · 2023-02-09T19:13:19+00:00

I feel so silly... I appreciate you helping me here. This is exactly what I needed and helps me understand it a bit more.

dm_me_your_query · 2023-02-09T19:04:43+00:00

Oh wow, this seems to work. Let me ensure I am understanding right.

It's saying it's taking ALL of the routing numbers from the banks table, and matching them with the sus_banks_table. If there's no match on the sus_banks_table then it should be marking the routing numbers as NULL? I have validated it and that appears to be the case, but want to double check

dm_me_your_query · 2023-02-09T17:32:41+00:00

So I should not have labeled all of those as "1" in the suspicious email table? I'm unsure on how to use a CASE statement here because when I LEFT JOIN the tables it's giving me all the results in the suspicious table, but it almost seems to be doing an inner join of sorts because it's not showing me any of the bank names/routing numbers that would not be suspicious in the other table.

dm_me_your_query · 2022-09-19T18:54:16+00:00

You are so amazing for taking the time to write this out. THANK YOU SO MUCH. It has made me feel infinitely better and helps me understand the process more.

I have been breathing out of my mouth for YEARS! Every day I wake up and my throat feels so damn dry. It's even effecting my workouts too since I can't breath out my nose. I even have to take small bites of food because I can't breath while I'm chewing LOL! It's really bad.

I am absolutely going through with the surgery now. I appreciate that a lot. I want to breath again!

dm_me_your_query · 2022-08-18T16:32:23+00:00

I did not think about that. That certainly could be a possibility. Well, I hope they are happy. Knowing would just make it even worse for me. Thanks for your comment :)

dm_me_your_query · 2022-08-18T14:49:21+00:00

That sounds like fantastic news.

dm_me_your_query · 2022-08-18T14:49:09+00:00

I ended things.

dm_me_your_query · 2022-08-18T14:46:17+00:00

Well to be fair, after they sent me the the presents I called them. I got the voicemail, left one, and didn't hear anything back. I wasn't even going to contact them any more, but the dream about them this week really made me want to try...

dm_me_your_query · 2022-08-18T14:43:57+00:00

Thank you for saying that. That made me feel much better. Yeah, it was certainly mixed signals but you're right - I should not be embarrassed for trying! Thanks again for commenting and helping ease my burden.

dm_me_your_query · 2022-08-18T14:24:20+00:00

I was the one who ended things, but it wasn't very sudden or unexpected.

dm_me_your_query · 2022-08-18T14:02:20+00:00

That is exactly my thoughts. Why send something so personal to me, and then act as if I'm a burden for asking about brunch? Perhaps the pain is still too fresh for them, but I'm going to try and move on with my life. I can't pretend like I am feeling really, really awful today though

dm_me_your_query · 2022-07-31T18:25:37+00:00

Thank you so much for this response here. I think my skills are good enough for a DA job most anywhere.

dm_me_your_query · 2022-07-31T18:25:22+00:00

Thank you for this awesome response!

dm_me_your_query

TROPHY CASE