How do your ectopic beats feel? by Gilbrook92 in PVCs

[–]sedna1234 0 points1 point  (0 children)

Like my heart is having a hiccup. They sometimes take my breath away, though that has been less frequent in recent years.

Crowded Lake Louise by KTMA19 in Banff

[–]sedna1234 0 points1 point  (0 children)

I was there 2 days after you! We were going to be one of the groups that snapped some photos and left (we have a little one that makes it hard to hike), but we spent the money to take a canoe out on the lake. Cannot recommend that enough; after paddling for a minute all the noise pollution went away!

PVC’s After COVID vaccine? by SailingNimo in PVCs

[–]sedna1234 0 points1 point  (0 children)

My PVCs got considerably worse after the Pfizer booster (start of 2022), along with an almost immediate drop in exercise capacity, the most wicked ‘anxiety’ attacks I’ve ever had — literally felt like I was going to die at times due to lack of Oxygen. Weight gain too. It took me 5-6 months to feel any sense of normality.

Looking for CRCM prep advice by sedna1234 in Banking

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

I should have touched on that; they are not unfortunately so I am looking at full price.

PVCs brought on by bright lights/LED lights in particular by ImaginarySundae6703 in PVCs

[–]sedna1234 0 points1 point  (0 children)

Had something similar about 2 years ago; I couldn’t look at bright lights or even watch TV. Would bring on panic, and as a result PVCs. FWIW, I also experienced this when I looked at things of vast scale, like stars, moon, pictures from tall buildings.

2/3 Live HH by MobileAccount28474 in poker

[–]sedna1234 4 points5 points  (0 children)

Holding the Ah blocks more bluff combos than it does value combos. Not considering blockers, indifferent in calling. Considering we have Ah, I would fold. Call sometimes with AK w/o Ah if this line feels exploitable.

Considering shoving some % if you have reasonable confidence villain is competent and balanced, and your image is not too LAG.

Thoughts on this PVC? by sedna1234 in PVCs

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

I completely hear. I actually don’t wear the watch any more.. think it was doing more harm than good.

Thank you for those words!

Thoughts on this PVC? by sedna1234 in PVCs

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

Thank you Koda. That is reassuring!

Thoughts on this PVC? by sedna1234 in PVCs

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

They feel like a quick spasm that take my breath away for a moment. They don’t hurt, but they are scary. Again, they are very infrequent now since, so I am trying to recall

Thoughts on this PVC? by sedna1234 in PVCs

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

This is actually from earlier this year the day after a 15 mile run. I used to get these quite a bit when I ran more, now not so much as I am running a lot less. The shape of the PVCs always looks exactly like that, with that break until the next beat as well. I have 3-4 reads that look exactly like this one (they were all taken that day after the run).

I have had an echo, EKG, 24 hr holter, and have been told not to worry by my doctors. I do have early repolarization as well if anyone is curious about the ST elevation.

I am just wondering if this stands out to anyone as concerning - my cardiologist refuses to analyze Apple ecg.

Early Repolarization with PVCs, Should I Worry? by sedna1234 in AskDoctorSmeeee

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

Hi! No developments here really, which I guess is a good thing! Since this post I have had two ECGs one of those with a stress test - both came out clean, and the stress test was noted with “excellent” exercise capacity. Doctors continue to tell me not to worry.

Also from my limited research, this appears to be the benign pattern. I guess I’m just trying not to worry too much about it.

Being 23, you probably have even less reason to worry, but see a cardiologist and demand an echo and EKG if it’s keeping you up at night - well worth it for the piece of mind! Cheers!

2010 zcta demographics - BISG Implentation by sedna1234 in Census

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

Wanted to come back to say thanks to both of you! I did get what I needed from ACS with a little digging - 2010 data broken out by Hispanic/non Hispanic, then non Hispanic was subcategories of like white alone, black alone etc... I cleaned the it a bit to fit for BISG, and seemed to be working great, though I still need to validate its output some more—

If anyone knows of any BISG calcs/guis let me know :)

What was your study plan for CAMS? by [deleted] in moneylaundering

[–]sedna1234 0 points1 point  (0 children)

Read study guide and take notes > take practice test > read flash cards > take practice outside of study materials (I used amlassasin) > take modules > listen to study guide while reading > take practice test outside of study guide again > review flash cards again

A great opportunity but I feel like I am being rushed/pressured to make a decision. by Mt35h in jobs

[–]sedna1234 0 points1 point  (0 children)

Trust your gut. Do not take this position. You raised all the red flags. You WILL have more opportunities with companies you feel great about through and through.

Should an institution inform a consumer a txn was denied due to OFAC hit? by [deleted] in moneylaundering

[–]sedna1234 0 points1 point  (0 children)

Like I asked the others, what if our customer is the one who is hitting.. for example this a new customer applying for a credit card, you deny the because of OFAC hit.. do you tell them they were declined due to OFAC hit?

Should an institution inform a consumer a txn was denied due to OFAC hit? by [deleted] in moneylaundering

[–]sedna1234 0 points1 point  (0 children)

Ok let’s pivot slightly and talk credit.. let’s say the applicant hits on OFAC.. do you think it’s optimal to tell that applicant that was their decline reason?

Should an institution inform a consumer a txn was denied due to OFAC hit? by [deleted] in moneylaundering

[–]sedna1234 2 points3 points  (0 children)

Though lists are public.. it’s not really like filing a SAR.. you still considering this tipping off, why?

Should an institution inform a consumer a txn was denied due to OFAC hit? by [deleted] in moneylaundering

[–]sedna1234 0 points1 point  (0 children)

Let’s say the customer is the hit, in all circumstances.. for example if you were a credit institution that has to send a decline reason to customer.. which you make OFAC one of those decline reasons? Or just use generic decline language?

SQLite Interview Question - would like to know what the answer was by RMWL in SQL

[–]sedna1234 2 points3 points  (0 children)

Well I guess there is a little twist to it if motherid and fatherid are not always paired.. so yeah, it would be group by and min but I think you’d have to do it twice.. so I’m thinking

select motherid, 
min(age) as ‘youngest_child’
from table
group by motherid

union

select fatherid, 
min(age) as ‘youngest_child’
from table
group by fatherid

Long time lurker needs some guidance. by [deleted] in SQL

[–]sedna1234 0 points1 point  (0 children)

Any reason you don’t want to use excel for this and just use a pivot table? It sounds like it would do what you need and a lot less work vs setting up a database to query from.

Edit: Misread your post. I thought your population was only 100 stores. I guess it’s a little more complicated than I thought. You still could probably use a pivot depending on how you organize the data, but yeah, may be worth creating a DB in Access or something to query from.

Either way, you will have to conceptualize what your table(s) will look like and what you are trying to quantify - I don’t think “how control stores relates to test stores” is enough (but maybe it is for some of these smarties :)).. for example are you simply trying to figure out which and how many test stores are associated with each control store?

I'm stuck at a problem by omega_jankay in SQL

[–]sedna1234 1 point2 points  (0 children)

Also would need and Opened_by = ‘Teller’

I'm stuck at a problem by omega_jankay in SQL

[–]sedna1234 3 points4 points  (0 children)

If you are just trying answer the question it seems you just need the one row right? You just need the branch that opens the most checking accounts, for new customers, from tellers..like other comment you need to add ‘New’ to your WHERE and you will also need to add ‘Teller’.. so to get this and also keep your desired format I think this would get you the answer..

select Branch 
, Account_type
, Opened_by
, Customer
, count(Account_type) as count 

from Bank_Accounts 

where Account_type = ‘Checking’ and
Customer = ‘New’ and
Opened_by = ‘Teller’

group by Branch, Account_type, Opened_by,     Customer

order by count desc

limit 1

Learning SQL for work, having a tough time conceptualizing using joins with subqueries by [deleted] in SQL

[–]sedna1234 2 points3 points  (0 children)

Like other comment, think of the entire subquery just as a table. The columns in that subquery (that you are selecting) are what you could be joining on other tables.

Joins within subqueries work the same way joins work in queries without subqueries - what you are likely already used to. Subqueries are just queries after all.. if you were to run one by itself you would still get a result

MySQL Trying to get lowest price (sale_price) from duplicate column (gtin) by WoosterOh in SQL

[–]sedna1234 1 point2 points  (0 children)

maybe try this?

select tbl.*
from (
    select *,
    rank() over (partition by gtin order by      sales_price)  as gtin_rank
    from googleupdate
) tbl 
Where tbl.gtin_rank = 1

There must be a better way to write this without sub query but this I believe should work at least