Example raw sql in Django

raw.py

from django.db import connection

def categories():
  sql = '''
    SELECT 
      SUM(pageview) AS pageview__sum, 
      substring(url from '^/[^/]+/') AS category
    FROM portal_tracker
    GROUP BY substring(url from '^/[^/]+/')
    HAVING substring(url from '^/[^/]+/') IS NOT NULL
    ORDER BY pageview__sum DESC
    '''
  with connection.cursor() as c:
    c.execute(sql)
    return c.fetchall()