Every derived table must have its own alias
What is the error "Every derived table must have its own alias" in MySQL?
US tourism/business visa from non-resident country I applied for multiple visas before (not US visa), but all of them were from my residence country. In all of these cases, I can get official paper which support my evidence (bank statement, letter which states I am employed with high salary, marriage certificate, security clearance, ...).  It is the same question as , but I am not residing; I have a business visa.  case-specific details: I am from Egypt, I have business visa for Ireland. While in Ireland, I want to apply for US business visa.  Why not to apply from Egypt? Because the waiting time is too long (75 days). The waiting time in Ireland in only 18 days. Both visits (Ireland, US) are short visits (3 weeks for each). Superscript outside math mode Infinite Series $1+\frac12-\frac23+\frac14+\frac15-\frac26+\cdots$ Was given the following infinite sum in class as a question, while we were talking about Taylor series expansions of $\ln(1+x)$ and $\arctan(x)$: $$1+\frac12-\frac23+\frac14+\frac15-\frac26+\cdots$$  The question isn't homework or anything, just a thought tease. I tried for a long while but couldn't find anything remotely close. Thanks in advance for the help. Can space expand with unlimited speed? just after the Big Bang and before inflation the currently observable universe was the size of a coin. One millionth of a second later the universe was the size of the Solar System, which is an expansion much much faster than speed of light. Can space expand with unlimited speed? What is Ubuntu's status on the Meltdown and Spectre vulnerabilities? Any questions relating to status updates, or asking if anything is going to be patched for these vulnerabilities should be closed as duplicates of this question.    are in the news right now and sound pretty severe. I don't see any security updates from Ubuntu that cover these vulnerabilities.  What is Ubuntu doing about these vulnerabilities, and what should Ubuntu users be doing?  These are CVE-2017-5753, CVE-2017-5715 and CVE-2017-5754. On some Microsoft Access queries, I get the following message:  Operation must use an updatable query. (Error 3073).  I work around it by using temporary tables, but I'm wondering if there's a better way.  All the tables involved have a primary key. Here's the code:  UPDATE CLOG SET CLOG.NEXTDUE = (     SELECT H1.paidthru      FROM CTRHIST as H1     WHERE H1.ACCT = clog.ACCT AND     H1.SEQNO = (         SELECT MAX(SEQNO)          FROM CTRHIST          WHERE CTRHIST.ACCT = Clog.ACCT AND          CTRHIST.AMTPAID &gt; 0 AND         CTRHIST.DATEPAID &lt; CLOG.UPDATED_ON     ) ) WHERE CLOG.NEXTDUE IS NULL; How to cut the non-overlapping part of 2 shapes in Illustrator CS6 Get selected value in dropdown list using JavaScript Set "this" variable easily? Does it feel lately like all questions have already been asked and answered and there is nothing more to do? I think everybody with a history of participation can't help but notice the explosive growth of repeated duplicate questions. The work of looking for duplicates and then closing questions has overtaken the work of actually answering questions.  It's become virtually impossible to ask something which hasn't been yet asked. Lately I feel boredom each time I see a new question and start answering it only to realize after the first written sentence that I have answered similar questions five times over or seen them answered some ten times or more. I know where it's going to be going and what answers with what votes it is going to receive before any answer is even written.  It's obviously not the administration's fault, it is simply so. The questions is, what to do about it? Engaging more moderators to close and close duplicates won't work because it's already starting to repel users who get mad at their questions closed and become afraid of asking more or perhaps just go away.  The original idea of Jeff stated the the site is for questions that can be answered. Meaning no open-ended discussions. When I first read this I had a casual thought - well, and what's gonna happen when they all are asked and answered? Will it become a museum, a monument of wisdom and knowledge or what?  I'm not sure what to do about it. Perhaps deprecation/versioning of older questions so that their new versions can sparkle the tiresome evening...  POSTSCRIPTUM.  I recall Star Trek Voyager episode  when another Q asked Captain Janeway for asylum. He was tired of immortality and wanted to die. They opened a hearing and went on to visit the continuum to evaluate the living conditions there which caused the suffering and the wish to escape it in death. A lifeless picture presented itself to the visitors... a house lone in an open space, two people going about their business, nobody talking. When asked why they were silent, the following was said. It's been so long, all has already been said, all stories told, all jokes are made... there is nothing left to do...  Are we there as well?  UPDATE: Just saw this answer in another question:       Also, some of the core questions got asked early on in the life of the site. Great questions still come around from time to time, but many have already been asked.   Doesn't that confirm my point? Proving $\sum\limits_{k=1}^{n}{\frac{1}{\sqrt{k}}\ge\sqrt{n}}$ with induction Divisibility tests and remainder mod $9,11,99,101,999,1001\,$ (casting out nines and elevens) Now I have proved the following two problems:      (1) Prove that a number and the sum of its digits have the same remainder upon division by 9.    (2) Given an integer, consider the difference between the sum of the digits in odd positions (counting from the right) and those in even positions. Show that the difference has the same remainder as the number itself when divided by 11.    Then, I need help on the following problem:      Partition the digits of a number into groups of two and three, respectively, starting from the right. Treat these as two- and three-digit numbers, respectively, and proceed similarly as in the two problems above. What divisibility rules arise?    In fact, I did not quite get what this problem asks for and not clear about this process. Could anyone give me some hints on this, please?  Thanks in advance. sda1 -> Windows XP  sda2 -> Windows 7 sda3 -> Data Partition   I have created 4 primary partitions, I have 7xx GB left, how can I create one more partition? Windows & Ubuntu dual boot.No menu to choose OS? I just installed Ubuntu alongside Windows 7. Now I cant boot Windows 7 because it automaticaly boots Ubuntu without displaying boot menu. How can I get menu with options to choose which Os to boot? Can anyone help? How to test that Apex Batch finish() sends an email? I have a Batch class that sends an Email from its finish method and want to test that. a But....I cannot test it. The the above test fails as there was no email invocation at all. BUT: I see it in the Limits view of my Dev Console that indeed one email invocation happens. Why?!  The batch class:  public MyBatch implements Database.Batchable&lt;SObject&gt; {      ...      public void finish(Database.BatchableContext context) {         sendEmail();     } }   The test method:  @isTest private static void sendsEmailOnFinish() {      Test.startTest();        MyBatch b = new MyBatch();     Database.executeBatch(b);     Test.stopTest();       // Verify     System.assertEquals(1, Limits.getEmailInvocations()); }   I thought this might be connected to using Test.startTest() and stopTest() but even moving the assertEquals before the Test.stopTest() doesn't make my test run. My work has decided to issue their own  (CA) to handle different aspects of our work securely without paying for certificates.   Cryptographically sign emails Encrypt email contents Make access to things like the company  client-certificate based. Revoke the keys of former employees automatically   They sent me a .pem file, and I'm not sure how to add it to my Ubuntu install. The instructions sent were: "Double-clicking on it on a Mac should install it."&nbsp;  How do I proceed? Do I need to do something with  to create a .key, .csr, or .crt file? Am I using beta or stable? I have been doing so many sudo apt-get update/(dist-)upgrade since yesterday and  something happend - so that I am confused now whether I am using still beta or the stable version.   How do I figure that out? Number of non-decreasing functions? Let $A = \{1,2,3,\dots,10\}$ and $B = \{1,2,3,\dots,20\}$. Find the number of non-decreasing functions from $A$ to $B$.  What  I tried: Number of non-decreasing functions = (Total functions) - (Number of decreasing functions) Total functions are $20^{10}$. And I think there are ${20 \choose 10}$ decreasing functions. Since you choose any $10$ codomain numbers and there's just one way for them to be arranged so that the resultant is a decreasing function. However my answer doesn't match. Where am I going wrong? How can I directly compute the non-decreasing functions like without subtracting from total? Prove $3(x^2y+y^2z+z^2x)(xy^2+yz^2+zx^2)\ge xyz(x+y+z)^3$ if $x,y,z$ are positive real numbers,Prove:$$3(x^2y+y^2z+z^2x)(xy^2+yz^2+zx^2)\ge xyz(x+y+z)^3$$ Additional info:$\sum_{cyc}$ denotes sums over cyclic permutations of the symbols $x,y,z$. I'm looking for solutions and hint that using Cauchy-Schwarz and AM-GM because I have background in them.  Things I have done: Writing Left hand side in expanded form:$$LHS=3(\sum_{cyc}x^3y^3+\sum_{cyc}xy^4z+3x^2y^2z^2)$$ Right now I don't have good idea were to start(Is expanding and looking for AM-GM is good?).So any hint is appreciated. Source : This inequality can be found as Problem 42, page 13, in the book &quot;Old and New inequalities&quot; by Titu Andreescu, where it is attributed to Manlio Marangelli. I get weird > symbols in my output — what does it mean?