zL5a8XDH

1CREATE TABLE IF NOT EXISTS sequence_one AS 
2SELECT sequence, total, total*1.0/(SUM(total) OVER()) AS relative 
3FROM(SELECT sequence, Count(*) AS total 
4     FROM seq_one GROUP BY sequence ORDER BY total DESC) 
5     
6near "OVER": syntax error: CREATE TABLE IF NOT EXISTS sequence_one AS
7SELECT sequence, total, total*1.0/(SUM(total) OVER 
8     
9sequence
10--------
11e3a0b000
12e3a0b000
13e92d4030
14e59f3038
15e1a0c00d 
16     
17sequence | total | relative
18---------------------------
19e3a0b000 | 2     | 0.4
20e92d4030 | 1     | 0.2
21e59f3038 | 1     | 0.2
22e1a0c00d | 1     | 0.2