How do I find out whenever a value changes in a certain column?

Need help if anyone can offer!

I currently have my select statement returning the TOP 1000 * results from a table. They are CC numbers that are currently active. I’d like to see how I can go about writing a query that could show me what has CC numbers have changed.

If something has changed, it will send a report to the listed people. If nothing, then it does nothing. It only actions once something has happened. We have an inhouse system that will do the automated part… I just need a select statement that will return what has changed. If I can get some help on this, it would be amazing!

Thank you!

Write the SQL code to find the average charge by the family medicine physicians

We need to write the script to find the average charge of physicians who specialize in "family medicine.

But i’m confused on how to write this because when we look at the appointment table, where we find the appointment_charge, it only gives us the physician_ID. How to link that to the specialize table. Can anyone help me solve this problem?

This link below contains the diagram, tables and question. I am stuck at number 13. Take a look, it will make more sense 🙂 >>>>

How do Dimension Door and Find Steed / Find Greater Steed interact?

Find Steed has this sentence (and Find Greater Steed has an equivalent one):

While mounted on your steed, you can make any spell you cast that targets only you also target your steed.

Dimension Door has this restriction with regard to taking someone else with you, where the restriction is size is the important bit:

You can also bring one willing creature of your size or smaller who is carrying gear up to its carrying capacity.

Take a medium-sized character (such as a Bard with Magical Secrets) mounted on a summoned a large mount (such as a warhorse), casting Dimension Door:

Is it possible to make Dimension Door affect this mount?

How do I find a friendly, inclusive roleplay group online?

One of my queer friends is interested in joining a campaign online, and is looking for an inclusive, friendly group of players. She asked me how she’d find such a group. I’d love to answer her, but after years of roleplaying irl and online, I still have no idea how I’d accomplish such a feat.

Most of the time in online games, the issue of gender and sexual diversity isn’t addressed, so I tend to end up with groups where at least one person isn’t comfortable with a non gender binary character, or expresses ideas about gender that make me uncomfortable. It tends to eventually come up and ruin an otherwise fun game night.

I don’t want to play in a don’t ask, don’t tell roleplaying campaign. How do I find a group of friendly, inclusive players who can roll with lgbt characters?

When you find a trap, what do you know about it?

All I could find about this subject is in Detecting a Hazard:

When characters approach a hazard, they have a chance of finding the trigger area or mechanism before triggering the hazard.

Anyone who succeeds becomes aware of the hazard, and you can describe what they notice.

But what does this mean? Do you only know that there’s a trap, or the trigger of one, in that square? Do you know the whole trap statblock? Something else?

Efficient method to find patterns $\frac{a}{b}=k \frac{c}{d}$ in the set

I have a list of rules, the whole set is bigger, this is just a small part

rule1=MapIndexed[Subscript[A, First@#2]->#&,{0.017840140244041125`,0.03701275157916095`,0.051660116184981536`,0.08951663681268851`,0.11158027392659164`,0.11199090055895211`,0.11722479640123873`,0.12880796041375156`,0.13998629375261973`,0.14799408926444602`,0.1603406353916348`,0.1691630967698906`,0.17603820358593392`,0.17625123467649714`,0.19645343424258566`,0.21551707277352605`,0.2181102569613515`,0.23391774392335418`,0.2550771120859639`,0.268556465535236`,0.3048461639996855`,0.31092372219882125`,0.3127938111713915`,0.31392896827464023`,0.3409781586745735`,0.34596915956848695`,0.3529110816686192`,0.3616255919094322`,0.367472697175696`,0.3934402946502719`,0.4047693032887368`,0.4311153156718978`,0.4683757162129396`,0.46952099223657906`,0.5072262199843859`,0.5221019133548683`,0.5343944162249954`,0.547890105814087`,0.5599232760856494`,0.5668852126411741`,0.5798751142315612`,0.5934466012255624`,0.5974131205016744`,0.6095346242098095`,0.6435968663448772`,0.6590218413254265`,0.6941771182743655`,0.7420644764943874`,0.7438917323215621`,0.7969894568033051`,0.8000537128029253`,0.8374749504134635`,0.8407436273863764`,0.8616085956899902`,0.9112275732642781`,0.9275783068606626`,0.9389371022951489`,0.9437334963687791`,0.9593199516799973`,1}]; 

a, b, c, d are the four numbers in the set, and at most two are equal, satisfy the following relationship:
$ \frac{a}{b}=k \frac{c}{d}$
$ k$ is a rational number.
when $ k=1$ , The GroupBy based approach is fast enter image description here

GroupBy[#/#2 -> (#/#2 /. rule1) & @@@ Subsets[Keys@rule1, {2}],    Round[Last@#, 10^-10.] & -> First, Equal @@ # &] // DeleteCases[True] // AbsoluteTiming 

when $ k\neq 1$ , assume that $ k = 1/3$
It’s not easy to do with GroupBy, I thought of a way to use Gather, It’s much slower than the previous one enter image description here

Gather[#/#2 -> (#/#2 /. rule1) & @@@ Subsets[Keys@rule1, {2}],    Abs[#[[2]] #2[[2]] - 1/3] < 10^-10. &] // Select[Length@# > 1 &] // AbsoluteTiming 

I want to know if $ k\neq 1$ , is there a way to use Groupby instead of Gather, or other more efficient methods?
Thank you in advance.

Where can I find more lore on the Lady of Pain?

D&D 5e lore has precious little to say about the Lady of Pain. A search of DNDBeyond yields only 3 references in the entire 5th Edition corpus.

From the Dungeon Master’s Guide:

The city is the domain of the inscrutable Lady of Pain, a being as old as gods and with purposes unknown to even the sages of her city. Is Sigil her prison? Is she the fallen creator of the multiverse? No one knows. Or if they do, they aren’t telling.

From Mordenkainen’s Tome of Foes, in a section describing how the Raven Queen is thought to visit the souls of dead adventurers:

The Raven Queen’s reason for communing in this way is a matter of some dispute. Some sages posit that she is using people as pawns in an inscrutable game, the rules of which are known only to her and the Lady of Pain.

From a sidebar quote of a gnome living in Sigil, City of Doors, found in Mordenkainen’s Tome of Foes, in the section on the Gnomish pantheon:

Who forged the chains that bind Tiamat in Avernus? Why do the modrons go on the Great March? Who is the Lady of Pain, really? I can’t tell you, but the answers lie in the Golden Hills. And if Garl and his gang don’t know, it can’t be known.
— Griballix, gnome of Sigil

This is every reference to the Lady of Pain in 5th Edition Material.

What resources from earlier editions of Dungeons & Dragons have more detailed exposition on the Lady of Pain?

Ways to numerically find the monodromy group of an ODE

I’m interested in finding the monodromy group of some solutions of an ODE that I know only either approximately or numerically. For example, I might have a 3rd order ODE of which I cannot find exact solutions, but I can find them to very high accuracy as a series expansion. For the sake of the example, however, let me take an ODE of which I know the solutions, so I can compare whatever numerical method I have to the analytic solution.

Let me take the ODE $ $ f”(z)+\frac{(2-5 z) f'(z)}{4 z (1-z)}-\frac{3 f(z)}{64 (z-1)^2}=0$ $ that has the two linear independent solutions $ $ f_1=\frac{\sqrt{1-z}+\sqrt{z}+1}{2 \sqrt{\sqrt{z}+1} (1-z)^{1/8}}$ $ $ $ f_2=\frac{-\sqrt{1-z}+\sqrt{z}+1}{\sqrt{\sqrt{z}+1} (1-z)^{1/8}}$ $

Say that I start with $ 0<z<1$ , I analytically continue $ z$ to the complex plane, go around $ z=1$ , which is a branch point, and I come back to $ 0<z<1$ . From the explicit solutions, we can see that they change to $ $ \left( {\begin{array}{c} f_1 \ f_2 \ \end{array} } \right)\to \left( {\begin{array}{cc} 0 & \frac{1}{2} e^{-\frac{1}{4} i \pi }\ 2 e^{-\frac{1}{4} i \pi } & 4 \ \end{array} } \right) \left( {\begin{array}{c} f_1 \ f_2 \ \end{array} } \right) $ $

Now, let’s assume I don’t know exactly the form of $ f_1$ and $ f_2$ . Maybe I know them for example as a series expansions around z=0 with as many orders as I want. I wanna find out how the monodromy group acts on these solutions.

One way to do this would be as explained here. The idea is to discretize the path around z=1, solve the ODE as a series expansion in all of these points, and match these approximate solutions to the ones closeby. In this way we go around z=1 approximately. I’ve tried this and, assuming I’ve done this correctly, I get a sensible result, but even with 16 points and keeping 200ish orders of the series expansion, I get an error which is roughly 1-2%.

I would like to get these numbers with a higher precision. Is there any way that I could do this, without using the explicit form of $ f_1$ and $ f_2$ ? Maybe there’s a smart way of using NDSolve?

Cannot find password

Our site is built with WordPress. is always redirected to, however I don’t remember how this redirection is set.

I wanted to sign in the dashboard of WordPress, but my username and password did not work anymore (for long time I did not sign in). I tried to find my password, but the following page just hanged.

Does anyone why finding lost password does not work? Is it related to the redirection? Is there other way to sign in?

enter image description here

Where can you find Swords Secret online?

I was reading the Lore Warden (PRG:AG) archetype (careful, there is another Lore Warden archetype for fighter) and one of its features is the swords secret, but I cant find any of them online.

Swords Secret

A lore warden learns specialized techniques that help her to quickly analyze and defeat her foes. At 3rd level, a lore warden gains one swords secret, and she gains an additional swords secret for every 4 fighter levels gained after 3rd. Except where noted, a lore warden cannot select the same swords secret more than once.

I wasnt able to find this listed on d20pfsrd, nythys, or with a google search.