INSERT INTO sqlaccess_user_workload ( sql_text, username) 
VALUES (
  ' SELECT c.cust_state_province, SUM(amount_sold) AS dollar_sales 
    FROM sales s, customers c  
    WHERE s.cust_id= c.cust_id 
    GROUP BY c.cust_state_province ', 'SH');
 
INSERT INTO sqlaccess_user_workload ( sql_text, username) 
VALUES (
  q'! SELECT   c.cust_id, sum(s.amount_sold) AS dollars, p.prod_id,
          sum(s.quantity_sold) as quantity 
      FROM     sales s , customers c, products p
      WHERE    c.cust_id = s.cust_id 
        AND      s.prod_id = p.prod_id 
        AND      c.cust_state_province IN ('Dublin','Galway','Hamburg','Istanbul')
      GROUP BY  c.cust_id, p.prod_id !', 'SH');
  
INSERT INTO sqlaccess_user_workload ( sql_text, username) 
VALUES (  
  q'! SELECT   c.cust_id, sum(s.amount_sold) AS dollars, p.prod_id
      FROM     sales s , customers c, products p
      WHERE    c.cust_id = s.cust_id 
        AND      s.prod_id = p.prod_id 
        AND      c.cust_state_province IN ('Dublin','Galway')
      GROUP BY  c.cust_id, p.prod_id!',   'SH');

INSERT INTO sqlaccess_user_workload ( sql_text, username) 
VALUES ( 
   ' SELECT c.cust_id, SUM(amount_sold) AS dollar_sales
     FROM sales s, customers c 
     WHERE s.cust_id= c.cust_id
     GROUP BY c.cust_id ', 'SH' );

INSERT INTO sqlaccess_user_workload ( sql_text, username) 
VALUES (
   'SELECT t.calendar_month_desc, sum(s.amount_sold) AS dollars
    FROM sales s, times t 
    WHERE s.time_id = t.time_id
    GROUP BY t.calendar_month_desc', 'SH' );
               
INSERT INTO sqlaccess_user_workload ( sql_text, username) 
VALUES (
   'SELECT t.week_ending_day , p.prod_subcategory
      , sum(s.amount_sold) AS dollars
      , s.channel_id, s.promo_id
    FROM sales s , times t, products p
    WHERE s.time_id = t.time_id AND s.prod_id = p.prod_id
    GROUP BY t.week_ending_day, p.prod_subcategory, s.channel_id, s.promo_id', 'SH' );
               
COMMIT;
