Why are some nouns countable and others uncountable?
When can uncountable nouns be countable?
I've created main SELECT statement like below. For every row in Base table (base on IDKey I've added columns with values from result of INNER JOIN of few tables.  SELECT   IDKey,    Name,    (select Amount from Table1 INNER JOIN Table2 ... where ID=IDKey) AS AmountTypeX,    (select Amount from Table1 INNER JOIN Table2 ... where ID=IDKey) AS AmountTypeY FROM BaseTable   BaseTable:  IDKey Name  ---------- 1     Ian 2     John 3     Ann ...   INNER JOIN of few tables Table1, Table2... :   ID Amount Type -------------- 1  100    X 1  200    Y 2  300    X 2  400    Y 3  500    X 3  600    Y ...   Result looks like:  IDKey  Name  AmountTypeX  AmountTypeY ------------------------------------- 1      Ian   100          200 2      John  300          400 3      Ann   500          600 ...   Do you have any suggestion how to avoid this nested SELECT statements in the main query at the begining and made this query simpler and more effective ?  I wast thinking about PIVOTING of the INNER JOIN result to look like below (all data for particular ID in one row) and then JOIN with main query but Have no idea how to do this and is it possible.  ID  X   Y ----------- 1   100 200 2   300 400 3   500 600 ... Say I have a module $M$ over a ring $R$ that is   $1.$ finitely-generated, i.e. $\exists$ finite $X \subset M$ such that $M = \sum_{i=1}^{n} Rx_{i}, x_{i}\in X$ (but $X$ is not necessarily free)  $2.$ free, i.e. $\exists$ a basis $Y \subset M$ a.k.a. $Y$ is free and generates M, (but $Y$ is not necessarily finite).  Now I want to show, that there exists a finite basis for $M$. For vector spaces, this would obviously be trivial, but for some  $R$-Modul, I'm not sure how to proceed.   Furthermore, is every minimal generating subset of $M$ a basis? How to use a file in a jar as javax.net.ssl.keystore? I'm trying to do something like   URL clientks = com.messaging.SubscriptionManager.class.getResource( "client.ks" ); String path = clientks.toURI().getPath(); System.setProperty( "javax.net.ssl.keyStore", path);   Where client.ks is a file stored in com/messaging in the jar file that I'm running.  The thing that reads the javax.net.ssl.keyStore is expecting a path to the client.ks file which is in the jar. I'd rather not extract the file and put in on the client's machine if possible. So is it possible to reference a file in a jar?  This doesn't work as getPath() returns null. Is there another way to do this? Since we're all into this OpenID thing, I think it would be really useful (and quite easy) to implement a friend invitation feature that grabs a list of friends from one's webmail contact list with an option to choose who to invite to SO, SF or SU. Something in the line of Facebook's friend invitation and recommendation feature. Make CMD-Delete a keyboard shortcut in Apple Mail to move a message to the archive? How to access object attribute given string corresponding to name of that attribute Cannot start XAMPP on Ubuntu 11.10 I'm using biblatex for my references.  Normally, if I use \cite{source1, source2, source3}, I get a citation like  [3, 45, 98]   If I now want to give a page number for one of them, it looks confusing imho, as I should get (did not try it out up to now, honestly)   [3, 45, 78, p. 23f, 98]   So imho it would make sense to change one of the separator from a comma to e. g. a semicolon like:  [3; 45; 78, p. 23f; 98]   Question 1: Does that make sense, or are there other conventions for citing sources with and without page numbers together?  (Up to now I collected the citations without page number in one cite command and added singular \cite[][p. xy]{} commands for those with page numbers., so I'd get:   [3, 45, 98][78, p. 23f]   )  the \cites[]{}[]{}[]{} could also do that, but it also uses the same separators for entries and postnotes.  Question 2: How could I change the separator globally for those number-citations from comma to semicolon in biblatex? Can the notion of vector space or algebra over a field be meaningfully extended to fractional dimensions, so that for example $\mathbb{R}^{-2/3}$ makes sense? Has this been explored somewhere?  I know that super vector spaces can be thought of as one way of generalizing vector spaces to negative integer dimensions. Is there a similar concept for dimensions that are rational numbers? I'm not talking about Hausdorff dimension, because it doesn't allow for negative rationals, and I'm rather looking for extensions from a more algebraic point of view (dimension as the trace of the identity map), without recurring to a given metric. Mafia 3 no more damage to be dealt barclay mills I did most of the barclay mills missions and brought the damage down to 2550 but now I can find anything else to damage or steal, so the meter is stuck at 2550 and the objective says "find and destroy garbage barges" but when I click it, no waypoint.  Please help. Gel circular polarising filter I am contemplating buying a lens that only takes rear gel filters. Is it possible to buy a circular polarising filter in gel format? If so, who can supply them (preferably UK based)? Let's say I have 1m of 2,5mm² copper wire, insulated with H07V-K. The wire carries 40A and environment temperature is 25°C. The wire is suspended in free air. How hot will the wire get? And how can I calculate it for other values?  The use case is a 12V-230V AC converter I want to hook up to my car and determine the minimum wire thickness required. Because it's only used from time to time and not buried in a wall I suspect I can use thinner wires. This is a temporary thing and doesn't need to be up to code. How does light speed up after coming out of a glass slab? As I learned today in school, my teacher told me that when light enters a glass slab it slows down due to the change in density and it speeds up as it goes out of the glass slab. This causes a lateral shift and the light emerges out from the point different than that from where it should have actually emerged from.  Okay so what I mean to ask is, when light enters point A on glass slab and emerges from point C why does the light speed up? Where does it get the energy it has lost when it entered the glass slab?  P.S.: Also, if I place a very very very large glass slab and make a beam of light pass through it will the light never come out as all the energy was lost in place of heat? Include the option to flag posts as spam in the Low Quality queue I guess this is an additional to previous requests like  and .  But I just came across  review item, and was unable to flag it as spam.  edit: Since I posted this, the item has been removed (deleted) here is a screenshot: Let $A$ be an $n \times n$ matrix with real enteries. Define $\langle x,y\rangle_A = \langle Ax,Ay\rangle, \quad x,y \in \mathbb R^n$ , where $\langle,\rangle$ is a standard inner product on $\mathbb R^n$. Then  $\langle x,y\rangle_A$ is an inner product iff  1)  $\ker A = \{0\}$.  2) $\operatorname{rank} A= n$.  3) all eigenvalues of $A$ are positive.  4) all eigen value of $A$ are non negative.  Clearly if $\ker A \neq \{0\}$, then there exist $x \neq 0$ such that $Ax =0$, then $\langle Ax, Ax\rangle_A = 0$, then $\langle ,\rangle_A$ is not inner product, so $\ker A = \{0\}$, thus rank of $A$ is $n$.  I am unable to check the 3) and 4) option. Please help to check the other option. Thank you Does this recording sound like the pulses emitted by bats? Out of curiosity, I recorded sounds in an area with lots of bats, hoping to be able to &quot;hear&quot; the bats communicating by lowering the ultrasound to a level down to the frequency which can be heard by a human. After a bit of post-processing, I actually hear interesting sounds, but I'm not sure about the origin. It seems that the frequency of the pulses is too low compared to bats. . Are those actual sounds emitted by bats? If not, what other animal could be the source of those sounds? About the audio The sound was recorded at 10 p.m. at  near a river, with more of a dozen bats flying in this zone. There is a bridge nearby, and the sides of the river are flat concrete, which means that there are a lot of opportunity for sound reflection (although high frequency sounds don't reflect well). Zoom H5 with the default XY directional microphone was used. The bitrate was set to 24-bit. Unfortunately, I used the sampling frequency of 48 kHz instead of the maximum 96 kHz. The following transformations were made to the original audio:  The pitch was shifted by -12 semi-tones, which means that the 20 kHz sound becomes 10 kHz, and 15 kHz becomes 7.5 kHz.   All sounds below 6 kHz were removed.  The sound was amplified.  Severe noise reduction was applied to eliminate everything but the actual sounds emitted by the bats.   The empty parts of the audio were removed.  The sound was amplified once again.   Frequency The frequency analysis of the transformed audio a peak around 9 kHz (18 kHz in the original audio), slowly fading to suddenly drop at 16 kHz (32 kHz in the original audio).   contains many sources with different indications about the frequency range of the sounds emitted by bats, only a few referencing the frequencies low enough to be heard by a human:  Frequency Produced 10kHz-120kHz Ramsey, Gabriel, McGuirk, Phillips, Watenpaugh. Holt Physical Science. New York: Holt, Rinehart and Winston Publishers, 1986.  while most agreeing on the fact that bats use frequencies higher than 20 kHz.  Most bats use frequencies in the range 20-80 kHz, only a few bats use frequencies less than 20 kHz. Long, M.R. &amp; Savage, J.G. Mammal Evolution. New York: Harper, 1976: 108.  The observed range of 18..32 kHz seems too low compared to the sources, but I have an impression that the frequencies vary a lot between different species of bats. Pattern When viewing the audio track (see below), each cry consists of several pulses in two to three sub-groups which are in turn in two groups. Each peak is a bit less than 1 ms. The second group occurs from 40 to 200 ms. after the end of the first one. Each sub-group is separated by 5 to 10 ms. The frequency of every pulse doesn't vary, except the very first pulse. The first cry starts by a more quiet pulse at 6 kHz (12 kHz in the original audio). The second and third cries don't follow this pattern.  indicates that there are three categories of sounds emitted by the bats:  Short clicks,  Frequency-swept pulses,  Constant frequency pulses.   It looks like it's still the third category which we are observing here, and the overall pattern looks similar to the one described for the bats. The gap between the left and the right track is mostly irrelevant: at higher frequencies, microphones become more and more directional, and the sound is reflected less, which leads to such difference.     Note: this question was considered to be on-topic at Biology.SE on . 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 am looking for shapefiles or a list of suburb names for Melbourne and Canberra. I have ABS shapefiles, but I need to filter that to end up with only metropolitan suburbs.  My shapefile has codes in it for  - I just need to know which suburbs belong to the metros. Given the following class  public class Foo {     public int FooId { get; set; }     public string FooName { get; set; }      public override bool Equals(object obj)     {         Foo fooItem = obj as Foo;          if (fooItem == null)          {            return false;         }          return fooItem.FooId == this.FooId;     }      public override int GetHashCode()     {         // Which is preferred?          return base.GetHashCode();          //return this.FooId.GetHashCode();     } }   I have overridden the Equals method because Foo represent a row for the Foos table.  Which is the preferred method for overriding the GetHashCode?  Why is it important to override GetHashCode? When clicking continue on the first Boot Camp screen,  I am presented with a dialog that displays:     The startup disk does not have enough space to be partitioned.   You must have at least 39 GB of free space available.     This is despite "About this Mac" reporting 271GB of free space:    And "Disk Utility" reporting 268GB of free space:    Searching online I found  which suggested it was the result of Time Machine which i recently enabled and suggests to run sudo tmutil thinlocalsnapshots / 999999999999 which I did, it ran sucessfully, and I restarted, yet to no avail.  What is the solution to this instance of Apple's poor engineering?  Running macOS High Sierra 10.13.4 (17E202)