Number of orders for the past week

SELECT COUNT (id)  AS "Total Orders"
  FROM public.gdata_order
  WHERE createdat >= CURRENT_DATE - INTERVAL '1 week'
  AND createdat < CURRENT_DATE;

Number of sales for the past week

SELECT SUM (totalprice) as "Total Sales"
  FROM public.gdata_order
  WHERE createdat >= CURRENT_DATE - INTERVAL '1 week'
  AND createdat < CURRENT_DATE
  AND orderstatus ='OrderCompleted';

Sales Summary for the past week

SELECT
  COUNT(*) AS "Total Order",
  SUM(totalprice) AS "Total Sales",
  SUM(taxamount) AS "Total VAT Amount",
  SUM(discountamount) AS "Toral Discounts"
  FROM public.gdata_order
  WHERE createdat >= CURRENT_TIMESTAMP - INTERVAL '1 week'
  AND orderstatus ='OrderCompleted';

Order distribution in channels for the past week

SELECT
  channel AS "Channel",
  COUNT(*) AS "Number Of Orders"
  FROM public.gdata_order
  WHERE createdat >= CURRENT_DATE - INTERVAL '1 week'
  AND createdat < CURRENT_DATE
  GROUP BY
  channel;

Sales report for the past week

SELECT
  createdat AS order_created_date,
  id AS order_id,
  displayid AS display_id,
  integration,
  channel,
  locationname AS location_name,
  brandname AS brand_name,
  grossamount AS gross_amount,
  taxamount AS tax_amount,
  discountamount AS discount_amount,
  totalprice AS total_amount,
  netamount AS net_amount,
  status AS order_status
  FROM public.gdata_order
  WHERE createdat >= CURRENT_DATE - INTERVAL '1 week'
  AND createdat < CURRENT_DATE;

Top 10 sales items in the past week

SELECT
  itemname AS "Item Name",
  SUM(quantity) AS "Total Quantity"
  FROM public.gdata_order_line
  WHERE createdat >= CURRENT_DATE - INTERVAL '1 week'
  AND createdat < CURRENT_DATE
  AND itemtype = 'MENU_ITEM'
  GROUP BY
  itemname
  ORDER BY
  "Total Quantity" DESC
  LIMIT 10;

Location sales stats for the past week

SELECT
  locationname AS "Location Name",
  COUNT(id) AS "Total Orders",
  SUM(totalprice) AS "Total Sales"
  FROM public.gdata_order
  WHERE createdat >= CURRENT_TIMESTAMP - INTERVAL '1 week'
  GROUP BY
  locationname;