Query database demo

Maximum CPU time: 2,000 ms.
Table dow_jones_index (750 rows)
quarter INTEGER NOT NULL
stock TEXT NOT NULL
date TEXT NOT NULL
open REAL NOT NULL
high REAL NOT NULL
low REAL NOT NULL
close REAL NOT NULL
volume INTEGER NOT NULL
percent_change_price REAL NOT NULL
percent_change_volume_over_last_wk REAL
previous_weeks_volume INTEGER
next_weeks_open REAL NOT NULL
next_weeks_close REAL NOT NULL
percent_change_next_weeks_price REAL NOT NULL
days_to_next_dividend INTEGER NOT NULL
percent_return_next_dividend REAL NOT NULL
Table iris_flower_measurements (150 rows)
sepal_length REAL NOT NULL
sepal_width REAL NOT NULL
petal_length REAL NOT NULL
petal_width REAL NOT NULL
class TEXT NOT NULL
View iris-setosa (50 rows)
sepal_length REAL
sepal_width REAL
petal_length REAL
petal_width REAL
SciLifeLab Data Centre
DbShare 2.7.10