That Moment...
You know that moment when you see this...
And the mage rolls need....
Yeah, that's the kind of day I've had.
More World of Warcraft topics to follow...
Development : No Great Shakes at SQL
I was just handed a technical test, this was for a job interview, and I was a little... well I'll say surprised, but then shocked, by the reply, lets take a look... I was handed these SQL statements, in several questions, and then told to summarise what I should see on any output of the various instructions.... create table customers (id INTEGER PRIMARY KEY, name Text, age INTEGER, weight REAL); insert into customers values(73, "Brian", 42, 33); insert into customers values(1, "Helen", 12, 12.5); select * from customers; SELECT name, CASE WHEN age > 18 THEN "adult" ELSE "minor" END "type" FROM customers; create table orders (id INTEGER PRIMARY KEY, customer_id INTEGER, desc TEXT); insert into orders values (0, 73, "Apples"); insert into orders values (1, 73, "Oranges"); insert into orders values (2, 1, "Bananas"); select * from orders; SELECT customers.name, orders.desc FROM customers JOIN orders ON ...
Comments
Post a Comment