challenge-090/abigail/sql/ch-1.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

SELECT  LENGTH (sequence) || char (10) ||
        REPLACE (
            REPLACE (
                REPLACE (
                    REPLACE (
                        REPLACE (
                            REPLACE (sequence, 'A', 'x'),
                        'T', 'A'),
                    'x', 'T'),
                'G', 'y'),
            'C', 'G'),
        'y', 'C')
  FROM  DNA;