mikeizbicki / cmc-csci143

big data course materials
40 stars 76 forks source link

has anyone figured out 18? #462

Closed giffiecode closed 8 months ago

giffiecode commented 8 months ago

my 15-17 all works, so I added

to_char(100.0 * revenue / sum(revenue), "999.99") || "%" as "percent revenue"

to my query from question 17. However, it's giving me an syntax error. Anyone knows how to fix this?