@WorldEngineer Is that good? Our grades are %...

Oh that is good then...

@Rachel - Should that edit have been a comment instead, or was it just incorrect?

@NickChammas What edit are you referring to?

@Rachel programmers.stackexchange.com/suggested-edits/4927

@NickChammas Oh a nested query like that in a sql statement is called a sub-query, not a derived table

For example, if you search "nested query", the top link is this article on subqueries which states "Subquery or Inner query or Nested query is a query in a query."

@Rachel Certainly, a query within a query is a subquery. However, a table defined as the output of a subquery is called a derived table. In the question I edited, the OP is naming the derived table. This is clear if you consider how the OP would select a column specifically from the derived table (say, if it was joined to some other tables).

It would be _.col1, which indicates that _ is a table identifier, though that table is indeed defined as a query.

A subquery which I would refer to as a subquery is typically found in the SELECT or WHERE clauses. When it's in the FROM clause it defines a derived table.

@NickChammas Hrrm I learn something new every day, thank you :) xaprb.com/blog/2005/09/26/sql-subqueries-and-derived-tables

@Rachel No problem.

@WorldEngineer If you don't already have it, Head First Design Patterns

shop.oreilly.com/product/9780596007126.do

@YannisRizos About your revision here, do you have the actual number of how many were migrated? I'd like to find out what % of our closed questions come from migrations

@Rachel 70-80... But that's a very small number compared to all the questions that are asked here after being closed on SO. The typical thing is that some jackass posts a comment on a closed question that it should be asked on ProgSE, and well, the rest is history...

@Rachel Also Goma asked about 20 questions this month...

In various incarnations...

@Rachel If you take out dupes, migrations, Goma, and SO crap, our close rate is not that bad actually...

@YannisRizos Is the 70-80 questions for the 90-month period?

@Rachel Yes but again you are trying to make sense out of numbers that don't...

The problem is not the amount of closed questions, the problem is the lack of any actual effort to salvage those that just need some love...

So.... you're saying the majority of our closed questions are salvagable?

@Rachel No. I'm saying that there are salvageable questions that we don't salvage. Never said anything about majority...

@YannisRizos Ok, thanks

@Rachel This ^^^ is great, thanks.

@YannisRizos Was the 70-80 the number of questions closed that were migrated, or the number of questions migrated?

@Rachel Closed.

@YannisRizos :) Note that I wasn't one of the people who downvoted there. No need to drive away new users who don't understand the site

@YannisRizos Thanks

@Rachel Oh, but you were one of the people who downvoted...

(off topic carries an automatic downvote, no one downvoted, it's the closure that lead to -1)

Hrrrm is that new? Guess I should upvote to reverse my downvote ;)

@Rachel No, not new... Up voting would be bad, you don't want to send the message that the question is good when it's not.

Well there's already 2 upvotes to counter 2 downvotes. I merely want the question score to stay at 0

I'm off, cya later :)

@Rachel That's not nice, 2 people are lying to the poor girl...

And 2 people are putting her down for not understanding the site

@Rachel I never said it was either or... The automatic down vote was enough, every other vote after that is just silly

How do you maintain your tickets, milestones, -- with Git repos?

(I currently use BitBucket but I am now in problems because I killed/remixed one repo but I need its milestones and tickets to other repo, not wanting to do it manually...)

...investigating redmine