1. select name,sequence_length from gene join sequence using(gene_id) order by sequence_length desc limit 10;

2. select name,sequence_length from gene join sequence using(gene_id) order by sequence_length asc limit 10;

3. select count(distinct description) from gene;

4. select count(name) from gene;

5. select description from gene where name ilike '%aco005884%';

6. select description from gene where gene_id = 4341;

7. select description from gene order by description limit 1;

8. select description from gene order by description desc limit 1;

9. select count(description) from gene where description like 'A%';

10. select count(distinct description) from gene where description like 'A%';

11. select name,description,sequence_length from gene join sequence using(gene_id) where description like 'A%' order by sequence_length desc limit 1;

12. select name,description,sequence_length from gene join sequence using(gene_id) where sequence_length >= 118 and sequence_length <=120;

14. select name,description,sequence_length from gene join sequence using(gene_id) where description ilike '%ribosomal%' order by sequence_length desc limit 1;

15. select name,sequence_length from gene join sequence using(gene_id) where sequence_length <= 50 OR sequence_length >= 3000;

16. select name,description from gene where name in ('Aco000443.1','Aco000775.1');

17. pineapple_backup=# \o exercise17.txt
pineapple_backup=# select * from organism join gene using(organism_id) join sequence using(gene_id) where gene_id in (427,752);
pineapple_backup=# \o