Advertisement
frolkin28

sla sql query

Oct 20th, 2021
2,130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.40 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement