Skip to main content
These examples assume you named your shared database VETCOVE_MANUFACTURER_DATA. Adjust the database name if you chose a different name during setup.

​
B2B Stock Availability by Supplier

Review recent product availability by market category and supplier: 
SELECT
    market_category_name,
    product_category_name,
    supplier_name,
    week_start_date,
    num_unavailable_statuses,
    num_total_statuses,
    availability_rate
FROM VETCOVE_MANUFACTURER_DATA.B2B_SHARE.STOCK_STATUS_BY_SUPPLIER_WEEK
WHERE week_start_date >= DATEADD('week', -12, CURRENT_DATE())
ORDER BY week_start_date DESC, market_category_name, supplier_name;

​
Home Delivery Sales by Product

See recent Home Delivery sales by product: 
SELECT
    manufacturer_name,
    product_line_name,
    full_item_name,
    SUM(quantity) AS units_sold,
    SUM(monetary_amount) AS sales_amount
FROM VETCOVE_MANUFACTURER_DATA.HD_SHARE.HD_SALES_ORDER_ITEMS
WHERE invoice_date >= DATEADD('month', -3, CURRENT_DATE())
GROUP BY manufacturer_name, product_line_name, full_item_name
ORDER BY sales_amount DESC;

​
Home Delivery Autoship Mix

Compare autoship and non-autoship Home Delivery sales: 
SELECT
    is_autoship,
    COUNT(DISTINCT order_id) AS order_count,
    SUM(quantity) AS units_sold,
    SUM(monetary_amount) AS sales_amount
FROM VETCOVE_MANUFACTURER_DATA.HD_SHARE.HD_SALES_ORDER_ITEMS
WHERE invoice_date >= DATEADD('month', -6, CURRENT_DATE())
GROUP BY is_autoship
ORDER BY sales_amount DESC;