Deprecated: Assigning the return value of new by reference is deprecated in /home/ina/public_html/blog/wp-includes/cache.php on line 36

Deprecated: Assigning the return value of new by reference is deprecated in /home/ina/public_html/blog/wp-includes/query.php on line 21

Deprecated: Assigning the return value of new by reference is deprecated in /home/ina/public_html/blog/wp-includes/theme.php on line 540
Blog by Ina Centaur » vsc

 

SL Forced-Downtime & SQLzoo Fun Part II

Written by ina on Tuesday, 13 of May , 2008 at 12:27 am
Tags: , , , , , , , ,

I get so much done when SL is offline.

Finished makeup editions for Kassia and Dria, and also finally pdf2tga’ed the SL Shakespeare Company programme!

And now for more SQL fun @ SQLzoo

Two Table Join

1b. Show the who and the color of the medal for the medal winners from ‘Sweden’

SELECT who,color FROM ttms JOIN country ON (ttms.country=country.id) WHERE country.name=’Sweden’

1c. Show the years in which ‘China’ won a ‘gold’ medal.

SELECT games FROM ttms x JOIN country y ON (x.country=y.id) WHERE y.name=’China’ AND x.color=’gold’

2b. Show which city ‘Jing Chen’ won medals. Show the city and the medal color

SELECT city, color FROM games JOIN ttws ON (ttws.games=games.yr) WHERE who=’Jing Chen’

2c. Show who won the gold medal and the city.

SELECT who, city FROM games x JOIN ttws y ON (x.yr=y.games) WHERE color=’gold’

3a. Show the games and color of the medal won by the team that includes ‘Yan Sen’.

SELECT games,color FROM ttmd JOIN team on (ttmd.team=team.id) WHERE team.name=’Yan Sen’

3b. Show the ‘gold’ medal winners in 2004.

SELECT name from team JOIN ttmd ON (ttmd.team=team.id) WHERE ttmd.games=2004 AND ttmd.color=’gold’

3c. Show the name of each medal winner country ‘FRA’.

SELECT name FROM team JOIN ttmd on (ttmd.team=team.id) WHERE ttmd.country=’FRA’

Category: Amusing, Daily Sumly, Designs, Projects

SL Shakespeare Company’s Miniseason #2

Written by ina on Wednesday, 30 of April , 2008 at 10:08 am
Tags: , , , , , ,

SL Shakespeare Company Miniseason 2 Playbill!

Category: Projects

Who is Ina Centaur?

A 25-year old American polymath of Taiwanese ancestry pretending to be old and Caucasian in Second Life. Semi-retired independent scholar also dabbling as an independent artist in new media, particularly theatre and the humanities—notably Shakespeare. Programmer, playwright and novelist. Formal academic background in http://portfolio.inacentaur.com/ina/scientist, philosophy, and bioengineering.

This is largely a personal blog which isn't always up-to-date. There's no one definitive way to stalk me ;-).