How many swords made of Valyrian Steel are there at the end of Season 6?
How many Valyrian steel swords are there at the beginning of GoT, and who owns them?
i have a table like this  +--------+------------+-----------+ | id     | volume     | price     | +--------+------------+-----------+ |      1 | 1.0000     |  14250.00 | |      2 | 0.2500     |  14251.10 | |      3 | 0.2500     |  14250.00 | |      4 | 0.0050     |  14200.00 | |      5 | 0.5000     |  14255.01 | +--------+------------+-----------+   Simply if volume 1.7500, how to select like bellow by ordering(highest price)  +--------+------------+-----------+ | id     | volume     | price     | +--------+------------+-----------+ |      5 | 0.5000     |  14255.01 | |      2 | 0.2500     |  14251.10 | |      1 | 1.0000     |  14250.00 | +--------+------------+-----------+   And if volume 1.5000 it also select the least amounts of records needed to calculate to the input volume  +--------+------------+-----------+ | id     | volume     | price     | +--------+------------+-----------+ |      5 | 0.5000     |  14255.01 | |      1 | 1.0000     |  14250.00 | +--------+------------+-----------+   some guys say i cant do this with sql Simplest or nicest proof that $1+x \le e^x$ I am a graduate student in economics who recently converted to R from other very well-known statistical packages (I was using SPSS mainly). My little problem at the moment is that I am the only R user in my class. My classmates use Stata and Gauss and one of my professors even said that R is perfect for engineering, but not for economics. He said that many packages are built by people who know a lot about programming, but not much about economics and therefore are not reliable. He also mentioned the fact that since no money is actually involved in building an R package, there is therefore no incentive to do it correctly (unlike in Stata for example) and that he used R for a time and got some "ridiculous" results in his attempts to estimate some stuff. Moreover, he complained about he random number generator in R which he said was "messy".  I've been using R for just a little more than a month and I must say I have fallen in love with it. All this stuff I am hearing from my professor is just discouraging me.  So my question is: "Is R reliable for the field of economics?". Is it possible to split micro USB to USB cable so two cables (data + and data -) go to the PC with USB and two other power cables go to power brick? How can I sound proof bathroom walls? I'm trying to figure out the best, least intrusive way of sound proofing the walls of a bathroom. The bathroom shares a wall with my bedroom, and my 3 yea old's bedroom. The main problem is the sound of water running (plus every bump on the counter and everything) echos loud and clear through the wall into my sons room.  I found  and it seems like a good choice. Another option is adding another layer fo drywall with something like  between them. But all the walls and ceilings in the house are textured. So replacing just one or two walls in a room is just not possible.   This is the layout of the two rooms. I've added red box around the wall with the most noise.   Is there anything else I'm missing here that I could do to dampen the noise short of tearing the bathroom apart? In Episode 1: The Phantom Menace, Anakin's mother, Shmi, said that he does not have a father, although it seemed to me that she doubted that.  Is there a canonical answer as to who Anakin's father is?  If so, who? Ratio of Boys and Girls In a country where everyone wants a boy, each family continues having babies till they have a boy. After some time, what is the proportion of boys to girls in the country? (Assuming probability of having a boy or a girl is the same) How many research interests should be included in a statement of purpose/objective I am wondering how many research interest should be included in a statement of purpose. Is it better to include just one core interest or to include up to three as in my case? What would be the best approach to get the recordtype id I know of two approaches to get the recordtype id of a particular record type   Use SOQL   RecordType RecType = [Select Id From RecordType  Where SobjectType = 'Account' and DeveloperName = 'Business'];    Benifit here is if the admin changes the name of the record type, the code still works as we can use developer name   Using Describe  Map&lt;String,Schema.RecordTypeInfo&gt; rtMapByName = d.getRecordTypeInfosByName(); Schema.RecordTypeInfo rtByName =  rtMapByName.get('Business');    Saves on SOQL limits but uses a describe call.  What would be your choice and why   EDIT : Usage is for setting up recordtype while inserting records in apex or trigger Proper analyses for 2x2 contingency tables So I have multiple questions about the different types of analyses that can be used on a 2x2 contingency table and when different analyses should be used.   To open, I'll note that this stems from my efforts to find the appropriate analyses to run for research using categorical data in a 2x2 contingency table. In my case I have two conditions: control and experimental and within the experimental group there are two items of interest (say, Item A and Item B). In all cases I'm investigating whether an outcome occurs or not: How many experimental participants show the outcome on Item A? How many experimental participants show the outcome on Item B? How many control participants show the outcome? So in addition to comparing Item A with the Control group (A vs. C) and Item B with the Control group (B vs. C), I also want to compare Item A with Item B (A vs. B).   My understanding is that for between-subjects comparisons (e.g., A vs. C   &amp;   B vs. C) a  is traditionally used and that for within-subjects comparisons (e.g., A vs. B) that  is a common choice.   Question 1: is this an accurate understanding of the common choices for statistical tests using 2x2 contingency tables?    My follow-up questions, and where most of my confusion lies, are related to what to do when multiple observed cell counts are low (less than 10). I've explored numerous threads here, the Wikipedia pages for different topics (Yates's correction, Fisher's exact, etc.), a few journal articles, and descriptions in R-packages, but I have found conflicting views.   Some sources indicate that you should use , others say it's out-dated because, in addition to being overly conservative, it was only preferred because the other options were computationally intense.   Others say that you should use , but I've seen additional information suggesting that Fisher's exact test is only appropriate if you know both the row and column totals and that other options (Boschloo, Barnard, etc.) are generally more powerful. However, which of those to use is also not clear.  Finally, even others suggest that the Pearson's $\chi^{2}$ test is appropriate as long as the expected cell counts are not low.   I've seen some indication that these arguments occur for McNemar's test as well (e.g., continuity correction &amp; McNemar's exact test).  Question 2: Is the assumption regarding cell counts about expected cell counts or observed cell counts? If the observed cell counts are low, does that matter to the type of test that should be used?  Question 3: What is an exact test and when should exact tests be used?    In addition to answers to these questions, I would also greatly appreciate any suggestions as to books or articles I can read to learn more about this. Part of my struggle with all of this has been just general difficult finding clear information about these topics and how they relate to one another. I was working on a worksheet for class and came across this problem:      Let $\varphi:R\to S$ be an onto ring homomorphism with the property that every ideal of $R$ is principal. Show that the same must be true for $S$.    I honestly do not know how to do this one! How to fix task manager memory column if it shows lies I have a problem in showing memory in task manager with memory and paging columns. Why it shows so small size usage? And maybe anyone knows how to fix it?  Here is a screenshot(working set, memory, page pool) sorted by most consuming: An explanation of Hawking Radiation It worked with the pre-installed Ubuntu, but after re-installing Ubuntu dual-boot with Windows 8.1, the WiFi is not working.  Is there a driver for this adapter that will work on Ubuntu 12.04? implementing functions in a game List of lists changes reflected across sublists unexpectedly I needed to create a list of lists in Python, so I typed the following: my_list = [[1] * 4] * 3  The list looked like this: [[1, 1, 1, 1], [1, 1, 1, 1], [1, 1, 1, 1]]    Then I changed one of the innermost values: my_list[0][0] = 5  Now my list looks like this: [[5, 1, 1, 1], [5, 1, 1, 1], [5, 1, 1, 1]]    which is not what I wanted or expected. Can someone please explain what's going on, and how to get around it? Centering with \includegraphics not with \begin{figure}? I mess up with things when I try to use the figure-thing: the picture is not appearing with the correct alignment (apparently because I forget the float package). Now I want to use only the graphicx package with \includegraphics. How can I center the \includegraphics without figure?  Not working or doing centering to the document afterwards.  \includegraphics[width=0.5 \textwidth]{./Pictures/r.png}{\centering} \includegraphics[width=0.5 \textwidth]{./Pictures/r.png}\centering To be truly standards-compliant, must all functions in C (except for main) have a prototype, even if they are only used after their definition in the same translation unit? Why is removing instationarities a good thing when trying to forecast a time series? How would Gauss' law hold in time varying electric fields?