SQL:

In a table 'codons' with the the column Codon_sequence

and a different table 'amino_acid_properties' with the molecular mass for the column name

and a third table 'amino.acid.nomenclature' with the Name column in 'amino_acid_nomenclature' referenced to the Name column in 'amino_acid_properties'

Write a query to return the Codon_sequence for all amino acids sorted from smallest

to highest molecular mass.

Position 1 Codon_id Codon_sequence c1 TIT Position2 T Position3 Amino acid_id T a5 T c10 ATC A T a8 c11 ATA A T a8 c12 ATG A T G a 11 c13 GTT G T T a 18 c14 GTC G T a 18 c15 GTA G T A a 18 c16 GTG G T G a 18 c17 TCT T T a 16 c18 TCC T 0 0 0 a 16 c19 TCA T A a 16 c2 TTC T T a5 c20 TCG T G a 16 C21 CCT T a13 c22 CCC a 13 c23 CCA c A a13 c24 CCG G a 13 c25 ACT A C T a17 c26 ACC A C a17 c27 ACA A A a17 c28 ACG A C G a 17 c29 GCT G T a 1 c3 TTA T T A a 10 c30 GCC G C a1 c31 GCA G A a 1 Name Alanine Arginine Asparagine Aspartic acid Cysteine Glutamic acid Glutamine Glycine Histidine Isoleucine Molecular_mass Polarity Charge 89 non polar uncharged 175 polar positive 132 polar uncharged 132 polar negative 121 polar uncharged 146 polar negative 146 polar uncharged 75 non polar uncharged 155 polar positive 131 non polar uncharged 131 non polar uncharged 147 polar positive 149 non polar uncharged 165 non polar uncharged 115 non polar uncharged 105 polar uncharged 119 polar uncharged 204 non polar uncharged 181 polar uncharged 117 non polar uncharged Leucine Lysine Methionine Phenylalanine Proline Serine Threonine Tryptophan Tyrosine Valine Code Amino_id Symbol Name Alanine a1 Ala a 10 Leucine Leu a 11 M Met a12 N Methionine Asparagine Proline Asn a 13 P Pro a 14 Gin Glutamine Serine a 16 S Ser a 17 T Threonine Thr a 18 V Val a 19 W Trp Valine Tryptophan Cysteine Tyrosine a2 Cys a20 Y Tyr a21 Stop a22 Stop a23 D a4 E a5 F Stop Aspartic acid Asp Glutamic acid Glu Phenylalanine Phe Glycine Gly Histidine His Isoleucine lle a6 G a7 H a8 1 a9 K Lysine Lys