I've been working on this for a while now, but the documentation I've been reading is making it more difficult to understand, not easier. I have a table that I made. It has resources and the number of days that the resource has been checked out. A single resource will have multiple entries, one for every time it is checked out. So, resource ID 4 might have eight entries with 2, 4, 22, 5, 2, 9, 44, and 5 days checked out. In reality, most resources have dozens of entries. What I want is the 10th percentile, 50th percentile (median), and 90th percentile of days checked out per resource. I know I want to group by resource_id. I know I want to sort each resource by checkout_days. From there, it gets very complicated very fast with intervals and partitions with nothing defining what an interval or a partition is and what they do. Is there a plain English guide to doing this task? 68.187.174.155 (talk) 10:23, 3 July 2025 (UTC)[reply]

This belongs in Wikipedia:Reference desk/Computing. -- Verbarson  ^talk_edits 10:43, 3 July 2025 (UTC)[reply]

You are correct. I moved it. I didn't realize I was in the wrong section. 68.187.174.155 (talk) 11:00, 3 July 2025 (UTC)[reply]

Well you have to count the number of resources, then look up your sorted list for 0.1, 0.5 and 0.9 times the number of entries and pluck off the days total. Graeme Bartlett (talk) 12:03, 3 July 2025 (UTC)[reply]

I am sorry. I was not clear. I have 2,901,553 resources. Following that method, I would have to do it for resource 1, then resource 2, then resource 3... nearly three millions times. I am looking for a method where I can group by resource ID and get the percentiles for the resource. 68.187.174.155 (talk) 12:10, 3 July 2025 (UTC)[reply]

Please let me know if this does what I need:

select resourceid, percentile_cont(0.1) within group (order by checkoutdays) partition by (resourceid) from tempresourcedays group by resourceid;

That just does the 10th percentile (I hope). 68.187.174.155 (talk) 13:52, 3 July 2025 (UTC)[reply]

I agree that should work and is probably the best bet, but if the OP requires that the value returned needs to exist in the data, they can use PERCENTILE_DISC instead of PERCENTILE_CONT, keeping everything else the same. Matt Deres (talk) 15:16, 3 July 2025 (UTC)[reply]

I have a Dell desktop computer running Windows 11 and am trying to use Microsoft Outlook as my email client, as I have been doing for years. Some months ago, Microsoft provided New Outlook, which is a different user interface than Classic Outlook. I am satisfied with Classic Outlook and less satisfied with New Outlook, and so want to continue using Classic Outlook. I am using AOL, which uses Yahoo. I don't want to change email providers because I don't want to change email addresses. Until a few months ago, I was able to ignore New Outlook. Now, when I try to launch Classic Outlook and connect to the AOL (Yahoo) mail server, it tries to start up New Outlook, which in turn says that it needs to sync my mail files to the Microsoft Cloud. I have not been told why it is necessary to migrate my email to the Microsoft Cloud. So I have to ignore the attempt to start Classic Outlook, which attempts to resync or migrate my email, and I launch Classic Outlook again. Can someone explain, first, why is Microsoft being so persistent about trying to use New Outlook and to move my email to the Microsoft Cloud? Can someone explain, second, how do I get it to stop trying to convert my email to New Outlook and Microsoft Cloud?

I hope that my explanation of the problem has been clear enough so that someone can answer the questions. Robert McClenon (talk) 21:02, 4 July 2025 (UTC)[reply]

Maybe try uninstalling New Outlook? Aaron Liu (talk) 03:33, 6 July 2025 (UTC)[reply]

That might be a good idea, User:Aaron Liu. But since Classic Outlook and New Outlook are, or at least were, different user interfaces to the same program, can I uninstall New Outlook without damaging Classic Outlook? Robert McClenon (talk) 00:32, 7 July 2025 (UTC)[reply]

If they're two different entries under Add or remove programs, I think so. I did that. Aaron Liu (talk) 01:31, 7 July 2025 (UTC)[reply]

User:Aaron Liu - If I search on Add or Remove Programs, I get Apps > Installed Apps in Windows Settings (which is what I would have expected). I see one entry for Outlook. Does that cover one program with two user interfaces? Robert McClenon (talk) 18:13, 7 July 2025 (UTC)[reply]

Frankly I don't know.
Does the advice at https://answers.microsoft.com/en-us/outlook_com/forum/all/outlook-365-and-new-outlook-how-do-i-stop-it-from/8fb9b42b-dc67-4b2d-a65c-3725e6171c0b work? Aaron Liu (talk) 18:21, 7 July 2025 (UTC)[reply]

I will advice to move to linux, just an advice if you want more flexibility. [[User:Sys64wiki|Sys64]] (talk) 06:25, 10 July 2025 (UTC)[reply]

btw the verb is "advise"; "advice" is the noun, which you used correctly after the comma but not before
You don't need to switch to Linux to use a different email client without Microsoft nags. though i do use arch btw Aaron Liu (talk) 17:58, 10 July 2025 (UTC)[reply]

Sorry for word's hallucinations. However, I think I meant if you completely wants to get out of corporate propaganda and drama then linux is an option. It may seems unreasonable to move to linux just for an email client that doesn't overhead, but once you stick with it, you will know the complete difference. Sys64 message this user 05:19, 11 July 2025 (UTC)[reply]

I don't like conspiracy theories, but is Microsoft trying to migrate my email to the Microsoft Cloud because they want to analyze it for marketing? Robert McClenon (talk) 18:13, 7 July 2025 (UTC)[reply]

Good to see someone growing up on internet. This is not something they will, most of the corporations are doing this ever since they existed. Ever heard of NSA? Sys64 message this user 05:20, 11 July 2025 (UTC)[reply]

What is the definition of halting?
1-it will generate some loop
or
2-The machine would NOT be able to compute the input.168.227.189.254 (talk) 13:00, 9 July 2025 (UTC)[reply]

See halting problem. If you have further questions after reading that, come back and ask. 196.50.199.218 (talk) 13:22, 9 July 2025 (UTC)[reply]

The halting problem is defined as using a Turing machine, which is a formal abstract model of any computer program, to determine whether another Turing machine will halt, meaning whether a computer program will exit because it has completed its calculations. That is, can a computer program be written that will verify that another computer program will exit, as opposed to going into a loop? The answer is no. Turing showed that the halting problem is an undecidable problem. You can't write a program that will reliably determine whether another program will run to completion or enter a loop. This was one of the first cases of a proof that a problem is undecidable. The proof of undecidability is sort of a self-referential trick, but is logically sound in showing a limitation of logic. Robert McClenon (talk) 21:41, 9 July 2025 (UTC)[reply]

Bit tangential: Ever since I've first learned about this, I've wondered whether what I call the "restricted halting problem" can be solved: Can there exist a program (via a Turing machine) that can determine whether another program (via a Turing machine) will halt unless said program is the exceptional case featured in the proof by contradication? Aaron Liu (talk) 17:52, 11 July 2025 (UTC)[reply]

You may be interested in Busy beaver, that looks for the longest running machine that stops. Some simple cases can be determined simply. If you had a limit on the size of the program, perhaps the halting problem could be solved in theory (but not in practice). Graeme Bartlett (talk) 23:59, 11 July 2025 (UTC)[reply]