Is it possible to join these tables a view and combined columns?
How to concatenate text from multiple rows into a single text string in SQL server?
How to make clickable links and cross-references in pdfs produced by LaTeX? How are Clash of Clans multiplayer battles determined Are battles determined by level or trophies? Just curious. In Ubuntu 18.04, when moving the windows there is a resize effect that occurs when accidentally touching one of the screen edges.  This control was available in CCSM and Ubuntu Tweak in previous versions with Unity.  I'm not finding it in GNOME Tweaks.  I also searched the repository with:  apt search ubuntu.*tweak The meaning of various equality symbols How does one show that $$\sum_{k=0}^{n}\binom{n+k}{k}\frac{1}{2^k}=2^{n}$$ for each nonnegative integer $n$?  I tried using the  but I guess I am applying it incorrectly. With the snake oil technique we have $$F(x)= \sum_{n=0}^{\infty}\left\{\sum_{k=0}^{n}\binom{n+k}{k}\frac{1}{2^k}\right\}x^{n}.$$ I think I have to interchage the summation and do something. But I am not quite comfortable in interchanging the summation. Like after interchaging the summation will $$F(x)=\sum_{k=0}^{n}\sum_{n=0}^{\infty}\binom{n+k}{k}\frac{1}{2^k}x^{n}?$$ Even if I continue with this I am unable to get the correct answer.  How does one prove this using the Snake oil technique?  A combinatorial proof is also welcome, as are other kinds of proofs. Can an Indian travel to India with 50 days before passport expires? My wife is travelling from Philadelphia to India in January 2019 and, on her outbound trip, she will only have 50 days validity left on her passport. However, while in India, she will be renewing her passport. The reply from a similar question seems to answer point 1 below, but I wanted a second opinion to be sure.  Here are the questions we have:  Can she travel from the US to India via Doha, Qatar with passport validity of only 50 days? Can we make a reservation on Qatar Airways for the roundtrip travel using her current passport and before the return from India to the US update passport information on the reservation? How to partition my hard drive for Ubuntu use? Till now I was windows user. From now on I want to use only Linux.   I have 500Gb HDD. How do I partition it properly? I read that there is no right or wrong way, but still, I am confused. I did something and I have primary partition mounted on / (160Gb) which I believe is a OS and 350Gb extended partition of which I have 4Gb of swap and 346Gb mounted on /home.  I got used to C:\ and D:\ partitioning, but I don't see file system in that way. I am lost. Where is what? How can I make C:\ partition for OS and D:\ for apps, movies, music, photos. Or what I want is Windows way and I have to get used to Linux way? Uniform continuity of $f(x) = x \sin{\frac{1}{x}}$ for $x \neq 0$ and $f(0) = 0.$ For the $f(x) = x \sin{\frac{1}{x}}$ for $x \neq 0$ and $f(0) = 0,$ my text book asks the following questions.  (b) Why is $f$ uniformly continuous on any bounded subset of $\mathbb{R}$?   (c) Is $f$ uniformly continuous on $\mathbb{R}$??  The graph for the function is this.    For the question (b), if I take subset between $[0.2,0.6]$ or the subset where the slope is steep, I don't think the function is uniformly continuous because I think for a given $\epsilon&gt;0$, there is no unique $\delta &gt;0$ for the bounded subset. Therefore, it also cannot be uniformly continuous on $\mathbb{R}.$ However, the questions sounds like the function is uniformly continuous and the book says that it is uniformly continuous. The answer on the book says something but I need more explanation. Thanks. Relationship between $R^2$ and correlation coefficient I have a profile on AskUbuntu.com which is recognized on my StackEchange profile (). I have already asked and answered questions there. But even though I'm logged in stack exchange, Askubuntu does not see me as logged in. I have a long history of problems with that and though I have been able to access it up to end 2018, and I don't understand why it can't do it anymore. I have seen multiple questions about similar problems, but they all are older than 2018 and do not really helped me solve it. Amongst other, they proposed to log in with the same user and password, but using the same user and password on two different log in systems is a security hole. either your credential cookies are shared, or one should use different logging info. EDIT: it has been suggested to deactivate third party cookies blocking, but I do not want to ruin my browser's tracking protection. Custom blocks created as a plugin in a module not showing for Block::load() I have a couple of blocks that have been created using the ... extends BlockBase syntax in my module. They work perfectly fine, and I can add them on the blocks layout page, can add them into DS as a field, etc. They definitely exist fine.  However, when I try and render them using Block::load(), they won't show up, unlike other blocks that work fine.  For example, if I have the following docblock:  /**  * Provides a 'Cute Cats' Block.  *  * @Block(  *   id = "cute_cats",  *   admin_label = @Translation("Cute cats yo"),  * )  */  class CuteCats extends BlockBase { ... }   ... and then try and call it like this:  $block = \Drupal\block\Entity\Block::load('cute_cats'); return render(\Drupal::entityTypeManager()   -&gt;getViewBuilder('block')   -&gt;view($block));   Any idea why? Thanks in advance. \foreach not behaving in axis environment Am hesitant to ask yet one more embarrassing question, but I can't seem to see the problem with the \foreach in the MWE. It should produce several horizontal lines but only produces the one with the yValue as specified in the \newcommand{\yValue}{0.3}:  Code: \documentclass{article} \usepackage{pgfplots}  \newcommand{\yValue}{0.3}  \begin{document} \begin{tikzpicture} \begin{axis} [  ymin=0,  ymax=1,  xmin=0,  xmax=1, ]  \foreach \yValue in {0.00,0.1,...,1.00} {     \draw [red] (axis cs:0,\yValue) -- (axis cs:1,\yValue); }  \end{axis} \end{tikzpicture} \end{document} NVIDIA Driver Install Fails Why do I see a saddle in this picture of a computer screen? I am not entirely sure this is an appropriate question for PSE, however since many of you have such diverse backgrounds, I'll give it a shot.  I have noticed that when one takes a picture of a computer, TV screen with a phone, you can "see" what looks like a saddle phase portrait.     Why does this happen? Does it have any relevance to differential equations or other areas of math? Mathematical journal for an undergraduate I want to make someone a present by subscribing for him to a mathematical journal. (It should appear every month or every two months). The contents should be comprehensible to an undergraduate in mathematics, and be about a broad selection of topics (for example not only analysis).   I expect the content to be something like proposing interesting problems and then giving solutions with some references for further study. Are there some famous journals you could suggest me? More than one optional argument for newcommand The \newcommand macro allows to use an optional argument for the first parameter #1 with:  \newcommand{\mycommand}[3][defaultfor1]{blah blah blah}   Is it possible to have more than one option with \newcommand? what is the difference between kind, type and sort Getting the array length of a 2D array in Java Let's say we are talking about the indigenous pukapuka who live in Pluto.  What is correct: "the pukapuka people" or "the pukapuka peoples"?  I've read somewhere the usage of "peoples" in this context, and it has surprised me. This is something I've been curious about since starting this whole 'meta' thing a couple years back.     Let's say a user posts a feature request.   Under what circumstances is the feature-request read by staff? If staff decline to do anything (I'd guess it's some sort of triage), under what circumstances is the feature-request reevaluated by staff?     Let's say a user posts a bug.    Under what circumstances is the bug tested? What generally determines whether a verified bug is actionable? (And/or what are the criterion for deciding what to do?)     For both of the above, would it be possible to see a general-but-relatively-detailed flow for what happens to these questions?