fork download
copy 
  1. import re
  2.  
  3. pattern = r"(,\s*)[^,]*\sAS\b\s*"
  4. s = ("Select customer_name, customer_type, COUNT(*) AS volume\\nFROM table\\nGROUP BY customer_name, customer_type\\nORDER BY volume DESC\\nLIMIT 10\n")
  5.  
  6. print(re.sub(pattern, r"\1", s))
  7.  
Success #stdin #stdout 0.03s 9500KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Select customer_name, customer_type, volume\nFROM table\nGROUP BY customer_name, customer_type\nORDER BY volume DESC\nLIMIT 10
https://ideone.com/Bh94tM
language:
Python 3 (python  3.12)
created:
2 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!