This is the sample data that I've got     id program Community ID sdg     246 #NoWasteGiving2020 97 11   246 #NoWasteGiving2020 97 17   246 #NoWasteGiving2020 97 10     With the data on the table above, how do I get the data to just be shown in one row and the sdg shown in one row. so at the end of the day the data will look like this: 246   #NoWasteGiving2020  97  10,11,17  This is the query that I've wrote select Distinct a.id, a.title as program, b.community_id, c.goal_id as sdg from programs_program as a join associates_programcommunity as b on a.id = b.program_id join associates_communitygoal as c on b.community_id = c.community_id
Consider a database table holding names, with three rows:  Peter Paul Mary   Is there an easy way to turn this into a single string of Peter, Paul, Mary?
What is the relationship between ISO, aperture, and shutter speed? I know digital cameras have ISO options, and that ISO is the camera's sensitivity to light, but if you set  higher ISO then you can get a noisy image. I also know there are two other camera options, shutter speed and aperture.   What is the relationship of between them? Is there any equation, or something like that?  For example, if I set the ISO to 640, then how should I set the shutter speed and aperture? Positive and negative complex numbers? Can there be such a thing as positive and negative complex numbers? Why or why not?   What about positive or negative imaginary numbers?   It seems very tempting to say $+5i$ is a positive number while $-2i$ is a negative number. On an Argand diagram (complex plane) $+5i$ would be represented by a point above the horizontal axis while $-2i$ is a point below the horizontal axis. I changed my Blender Units to Metric System, but when I'm building things, my meshes are transparent, i.e. I can see through faces like in wireframe even though my wireframe is turned off. All faces have a light white in non-wireframe mode, but I can still see through them.   How do I reverse this?  Another issue I get is this    Looks like clipping is not working properly. Prove $\vdash \neg(\square F\land p)$ in $KD$ Adding Maximum and Minimum Latitude and Longitude as features in ArcGIS for Desktop? Android adware lets me opt out: is it safe? Recently my mom's phone running Android 5.0 has been infected with a piece of adware:    At first we thought this was caused by applications, but as you can see here, only the Google/METROPCS Internet browser is running.  In the photo, there is a button that reads 'opt out'. So I clicked on it and it took me to this link at http://tracker.tpc.re/optout/mobile/:    BUT both of these options smelly fishy. For starters, the manual app is not a download link in the play store but an APK, making it seem like a virus. The second (manual) as for sensitive information, which could harm me even more.   Which one of these options do I choose? Are they legit or do I have to do get rid of it another way? Is "guy" gender-neutral? Determining the name of the VMware host of a VM guest - from the guest How does one actually show from associativity that one can drop parentheses? After you get the Reindeer Stables, you can add decorations through a text form to increase production speed. I've added a few decorations myself, but I was wondering what all of them are. I know that some entries seem to be "synonyms". For example, if you enter "wreath" and then "garland", you'll only add the "a Christmas wreath" and trying to put up the garland will return "We already have a Christmas wreath".  These are the decorations I've already added along with discovered synonyms.   Nutcracker (Nutcracker) a Christmas tree (tree) baubles (bauble) glass ornaments (ornament) a star (star) Christmas lights (lights) a Christmas wreath (wreath, garland) mistletoe (mistletoe) a Christmas stocking (stocking) candy canes (candy cane) a chimney decoration (chimney, fireplace) a Santa decoration (santa) an elf decoration (elf) a reindeer decoration (reindeer) a nativity scene (stable) toys (toy) wrapping paper (wrap) candles (candles) tinsel (tinsel) a star (star) an angle (angle) holly (holly) paper chains (chains) Christmas crackers (cracker) Christmas cards (card) a figure of Mary (mary) a figure of Joseph (joseph) a figure of Jesus (jesus) wise men figures (wise men) a donkey decoration (donkey) a sleigh decoration (sleigh) a snowman (snowman) snow decoration (snow) Santa hats (hat) bells (bell) ribbons (ribbon) a turkey decoration (turkey) ? Example where convergence in mean does not imply convergence in quadratic mean Is there an example where convergence in mean does not imply convergence in quadratic mean. $E|X_n-X|\rightarrow 0$ but $E|X_n-X|^2 \nrightarrow 0$.  It seems like this should be fairly straightforward, but I cannot really come up with an answer.  I'd imagine the answer would look something like   $$X_n=\begin{cases}a &amp; \text{with probability } \frac{1}{n} \\\  0&amp; \text{with probability } 1-\frac{1}{n} \end{cases}$$ Fibonacci Sequence and series limits 1) Let $F_1 = 1$, $F_2 = 1$, and $F_n = F_{n-1} + F_{n-2}$ for $n \geq 3$.   How do you prove that  $$\sum_{n=2}^\infty \frac1{F_{n-1} F_{n+1}} = 1$$   $$\sum_{n=2}^\infty \frac{F_n}{F_{n-1} F_{n+1}} = 1$$   Do you even use the formula $n(n+1)/2$?   I tried using $F_{n-1} = F_n - F_{n-2}$ and $F_{n+1} = F_n + F_{n-1}$ and then trying to figure out how to substitute those, but I've been going around in circles. How would you solve this? What tips can you give me to solve this? Is there any website that teaches this? I tried searching google and youtube but none were helpful.   2) Let $s_x = \tan(2/x)$. Where does this become nonincreasing? While using monotonic limits to establish there is a limit.   I was guessing you need to use upperbound and lowerbound but doesn't it go to infinity? Any way to list similar commands? When you write the command name wrong, bash often does this:  septi@norbert:~$ good No command 'good' found, did you mean:  Command 'gold' from package 'binutils' (main)  Command 'gmod' from package 'gmod' (universe)  Command 'goo' from package 'goo' (universe)  Command 'god' from package 'god' (universe)  Command 'geod' from package 'proj-bin' (universe)  Command 'gord' from package 'scotch' (universe) good: command not found   Or sometimes it does this:  septi@norbert:~$ nftp No command 'nftp' found, but there are 23 similar ones nftp: command not found   Is there any way to ask bash to show these 23 similar commands for me? And, is there a way to show similar commands, including those that aren't yet installed, instead of running the application, ftp for example? How to disable the skype ads (advertisement)? Before Voldemort, who was the last Horcrux creator? Horcruxes are rare (and then seven come along at once...) and only a few people know about them.  But when was the last Horcrux before Voldemort's? 50 years before him? Centuries? Millennia? What application launchers are available for Ubuntu? Show that the $\max{ \{ x,y \} }= \frac{x+y+|x-y|}{2}$. Show that the $\max{ \{ x,y \} }= \dfrac{x+y+|x-y|}{2}$.   I do not understand how to go about completing this problem or even where to start. How to set an alias on a per-directory basis? Suppose you have an alias go, but want it to do different things in different directories?  In one directory it should run cmd1, but in another directory it should run cmd2  By the way, I have an aliases for switching to the above directories already, so is it possible to append the go alias assignment to the foo alias?  alias "foo=cd /path/to/foo"   Working in bash(?) on OSX. I have a directory with ~1M files and need to search for particular patterns. I know how to do it for all the files:  find /path/ -exec grep -H -m 1 'pattern' \{\} \;   The full output is not desired (too slow). Several first hits are OK, so I tried to limit number of the lines:  find /path/ -exec grep -H -m 1 'pattern' \{\} \; | head -n 5   This results in 5 lines followed by  find: `grep' terminated by signal 13   and find continues to work. This is well explained . I tried quit action:  find /path/ -exec grep -H -m 1 'pattern' \{\} \; -quit   This outputs only the first match.  Is it possible to limit find output with specific number of results (like providing an argument to quit similar to head -n)? How to redirect output of wget as input to unzip? I have to download a file from this . The file download is a zip file which I will have to unzip in the current folder.  Normally, I would download it first, then run the unzip command.  $ wget http://www.vim.org/scripts/download_script.php?src_id=11834 -O temp.zip $ unzip temp.zip   But in this way, I need to execute two commands, wait for the completion of first one to execute the next one, also, I must know the name of the file temp.zip to give it to unzip.  Is it possible to redirect output of wget to unzip? Something like  $ unzip &lt; `wget http://www.vim.org/scripts/download_script.php?src_id=11834`   But it didn't work.      bash: wget   http://www.vim.org/scripts/download_script.php?src_id=11834   -O temp.zip: ambiguous redirect   Also, wget got executed twice, and downloaded the file twice.