frolkin28

sla sql query

Oct 20th, 2021
1,841
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT bigl_company_recent_sla.id AS bigl_company_recent_sla_id,
  2. bigl_company_recent_sla.orders_delivered_percent AS bigl_company_recent_sla_orders_delivered_percent
  3. FROM bigl_company_recent_sla
  4. WHERE bigl_company_recent_sla.orders_total > 150
  5. AND CAST(bigl_company_recent_sla.date_updated AS DATE) = '2021-8-17'
  6. AND bigl_company_recent_sla.id > 0
  7. ORDER BY bigl_company_recent_sla.id
  8. LIMIT 5000
RAW Paste Data