SELECT identity, name FROM Gene;
| identity | name |
|---|---|
| 12 | 'Toll' |
| 1 | 'Son of sevenless' |
| 24 | 'OB' |
| 11 | 'OB' |
SELECT identity, name FROM Gene WHERE species='Homo sapiens';
| identity | name |
|---|---|
| 24 | 'OB' |
SELECT identity FROM Gene WHERE species='Drosophila melanogaster' AND name='Toll';
| identity |
|---|
| 12 |
SELECT MAX(seqlength) FROM Protein;
| MAX(seqlength) |
|---|
| 301 |
SELECT COUNT(*) FROM Protein WHERE species='Homo sapiens';
| COUNT(*) |
|---|
| 1 |