I am travelling to Hungary for an all expenses paid coding competition I have been invited to by a very well known company. I need to apply for a tourist visa.  I am currently residing in India and quit my job a few months back. I am freelancing now and have a decent income. Unfortunately I haven't registered myself as a business yet. Is this going to be a problem?  I have the following documents:    Return flight tickets Accommodation confirmation Invitation letter from the company stating the purpose and sponsorship on their letterhead 6 months bank statements showing income and consistent savings Travel insurance covering 50k USD 3 years of Tax Returns   Is there any risk of my visa getting rejected?
There are many visa applicants who are working as an unregistered freelancer (photographer, construction contractor, fashion designer, journalist etc ). Some of these freelancers make really handsome monthly income and don't really need to work as a full time employee. Most of them receive variable amount of payments (cash, cheques, demand drafts etc) When it comes to filling a visa application form (USA, UK, Schengen etc), there is always an employment section in all visa form, eg for Schengen visa employment form :    This is a very important factor to make an application really strong.  Questions:   1 Unregistered freelancers can just simply write their profession? what documents to produce along with the application?  2 Bank statements with variable methods of payments could convince the visa officer that these are all legitimate payments?
Do photons have acceleration? Photons travel at the fastest speed in our universe, the speed of light.  Do photons have acceleration? I have a table tabName with the following rows:  id(PK) .. Created(datetime)     Resolved(datetime) Status(new/resolved/open) 1          2015-05-10 00:00:00   1970-01-01 ..       open 2          2015-05-10 ..         1970-01-01 ..       new 3          2015-05-10            2015-05-12          resolved 4          2015-05-11 ..         1970-01-01 ..       open 5          2015-05-11 ..         1970-01-01 ..       new 6          2015-05-11            2015-05-11          resolved 7          2015-05-12 ..         1970-01-01 ..       open 8          2015-05-12 ..         1970-01-01 ..       new 9          2015-05-12            2015-05-12          resolved   NOTE:  1970-01-01 .. is default time for all the tickets which are still open.  I have to frame a query to get the count of tickets still open, date wise. Say like on 10 May I have 3 tickets opened. Noting that for id = 3, resolved date is not 10 but it's closed on 12 May.  I framed a query like  SELECT DATE_FORMAT(Created, '%d-%m') AS createdd, COUNT(1) FROM tabName WHERE DATE_FORMAT(Resolved, '%d-%m') &gt; DATE_FORMAT(Created, '%d-%m')       AND YEAR(Created) = '2015' GROUP BY createdd;   The above query gets all the tickets whose Resolved date is greater than the date which is considered for the count. This may count newer tickets as well. And also if the older tickets which are not resolved yet is not counted.  Is there any other way to frame the required query? I have been juggling with this query from last 3 days. Not able to find out still.  Updated: As suggested by Abhik, i have tried in sqlfiddle site.  Here is what i created:  CREATE TABLE test    (idint,createddatetime,resolveddatetime, status varchar(15), PRIMARY KEY (id));    INSERT INTO test       (id,'created','resolved',status`) VALUES       (1,'2015-05-10 00:00:00','1970-01-01 00:00:00','open'),    (2,'2015-05-10 00:00:00','1970-01-01 00:00:00','new'),    (3,'2015-05-10 00:00:00','2015-05-12 00:00:00','resolved'),    (4,'2015-05-11 00:00:00','1970-01-01 00:00:00','open'),    (5,'2015-05-11 00:00:00','1970-01-01 00:00:00','new'),    (6,'2015-05-11 00:00:00','2015-05-11 00:00:00','resolved'),    (7,'2015-05-12 00:00:00','1970-01-01 00:00:00','open'),    (8,'2015-05-12 00:00:00','1970-01-01 00:00:00','new'),    (9,'2015-05-12 00:00:00','1970-01-01 00:00:00','open')    ;   `   When i run  ` select created_date, @open:= @open+open_ticket-resolved as open from(  select   date_format(created,'%d-%m') as created_date ,  sum( case when status='open' then 1 else 0 end )+  sum( case when status='new' then 1 else 0 end )+  sum( case when status='resolved' and ( date(resolved) > date(created) or  date(resolved) = date(created)) then 1 else 0 end ) as open_ticket,  sum(case when status = 'resolved' and date(resolved) = date(created) then 1   else 0 end) as resolved  from test  where  YEAR(Created) = '2015'  group by created_date )x,  (select @open:=0)r order by created_date ; `  I got following output  created_date   open 10-05   3 11-05   5 12-05   8  Here count of still open tickets for 12-05 must be 7. The above query includes ticket id "3" , which is closed on 12-05. So is there any way to exclude this? If i am able to get this right, then i will have full fledged query. Where are the key wardens and where are my Infernal Machines to create a Hellfire Ring/Hellfire Amulet? In order to obtain a Hellfire Ring or Amulet, one has to work their way through the Uber Boss system of harvesting machines and organs to produce a legendary ring or amulet ().  To create the infernal machine required to open the portals to the Ubers, the keys are drops from mobs nick named Key Wardens.  Where are the various key wardens?  Are there any requirements for making the machines drop? What's the drop rate on different difficulty settings? I have been wondering what a gold piece is worth, due to the fact there are many things that cost the same, but in reality, are probably worth radically different prices, such as a Goat and a Whip, which both cost 1 gp.  What is a gold piece really supposed to be worth? Like, how would things be priced if they were in familiar modern monetary units instead of "gp"? That would give me something to base my adjustments to abnormal prices on, such as items not listed in the PHB. Many older movies seem to have vivid reds and particularly realistic or noticeable skin tones (they certainly seem to stand out from typical skin tones on TV or the majority of movies). This applies even in DVD or online versions and is not, given the range of material I've noticed the effect in, an artifact of special post processing or deliberate colour manipulation.  All the movies I've noticed the effect in are from the film era, especially from when colour became common to the late 1960's. I used to think it was just Technicolor but I've seen things recently that don't claim to be Technicolor that also show the effect.   claims the effect was due to the final print being constructed late in the process for separate black and white film strips for each primary colour allowing the final dyes to be very vivid and clear:     The rich colors that the Technicolor process gave came in part from the fact that the color was not added to the process until the final stages. The color information was recorded and processed as separate black and white images which were relatively easy to control and preserve.   Is this a good explanation? Arithmetic progression topology Story about a time-traveler living backwards in a capsule I'm hunting for the title of a short story where a senile old man appears in a capsule in a laboratory.  They eventually realize time is passing backwards for him. After years he helps them build the machine he's in, and he changes places with the him that has been aging normally in the timeline. \ifmmode doesn't seem to work correctly inside an array environment I’m struggling with getting \ifmmode to work correctly when used inside an array environment which is inside a displaymath environment.  Here is a minimal example:  \documentclass{article}  \newcommand{\signal}[1]{%   \ifmmode     1#1   \else     2$#1$   \fi }  \begin{document} \begin{displaymath}   \begin{array}{cc}     \signal{a} \signal{b} &amp; \signal{c} \signal{d} \\   \end{array} \end{displaymath} \end{document}   This example generates the following output:        Why doesn’t all invokations of \signal detect math-mode? If $x,y,z\in\mathbb R\setminus \{1\}$ and $xyz=1$, prove that $\frac{x^2}{(x-1)^2}+\frac{y^2}{(y-1)^2}+\frac{z^2}{(z-1)^2}\ge 1$. What is the purpose of -e in sed command? I can't find any documentation about the sed -e switch, for simple replace, do I need it?  e.g.  sed 's/foo/bar/'   VS  sed -e 's/foo/bar/' How can I convert JPG into PDF easily? Is there any way to batch convert .jpg files into single .pdf files? How to sort columns independently? I have a PC with an OEM install of Win 8 updated to 8.1.  It has 3 physical hard drives in it.  The drive where Windows is installed has a LOT of partitions on it already.    Can I install Ubuntu on a different physical hard drive than Windows, and be able to dual-boot?  I am able to boot to a live USB of Ubuntu 14.04, so I think I'm about ready to proceed.  But if I can make my installation easier by using a different physical drive, I'd like to do that. The error I am having when trying to update my package list.  W: GPG error: http://download.opensuse.org ./ Release: The following signatures were invalid: KEYEXPIRED 1436387333  W: Failed to fetch http://ppa.launchpad.net/samrog131/ppa/ubuntu/dists/trusty/main/binary-amd64/Packages  404  Not Found  E: Some index files failed to download. They have been ignored, or old ones used instead. I am looking for a reference which has a self-contained (elementary, that is, at the "undergraduate algebra level") proof of the the fact that any one-dimensional Noetherian UFD is a PID. Does anyone know such a reference?   (Note: I have looked at the similar questions on this website but don't find them particularly useful). Find the representing matrix with the respect to the standard basis Let $\Bbb R^2$ be a finite-dimensional vector space and $T:\mathbb{R}^2\to \mathbb{R}^2$ a linear operator. Let $[T]_B =  \begin {bmatrix}0 &amp; 0 \\-1 &amp; 1 \end{bmatrix} $ be a matrix representation of $T$ in the basis $B= (1,1),(-1,0)$.   How can I find the matrix $[T]_E$ where $E$ is the standard basis $(1,0),(0,1)$ if the transformation isn't given in the question?  Thanks,  Alan What are the differences between Holmes, Moldvay, and Mentzer D&D? example of discontinuous function having direction derivative Is there a function (non piece-wise unlike below) which is discontinuous but has directional derivative at particular point? I have a manual that says the function has directional derivative at $(0,0)$ but is not continuous at $(0,0)$. $$f(x,y) = \begin{cases} \frac{xy^2}{x^2+y^4} &amp; \text{ if } x \neq 0\\  0 &amp; \text{ if } x= 0 \end{cases}$$  Can anyone give me few examples which is not defined piece wise as above? Coloring lines inside textarea Is $\mathbb{R}^\omega$ endowed with the box topology completely normal (or hereditarily normal)?