Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. ----------------------------------------------------------
  2. | provider id| 1-1-2019 | 1-1-2019 | 1-1-2019 | 1-1-2019 | -> dynamic
  3. ----------------------------------------------------------
  4. | 5 | 5 | 3 | 9 | 8 |
  5. ----------------------------------------------------------
  6. | 18 | 11 | 56 | 79 | 34 |
  7. ----------------------------------------------------------
  8.  
  9. select `providers`.`id`,(select `orders`.c
  10. from `orders`,`providers`
  11. where
  12. `orders`.`providerId` = `providers`.`id`
  13. and
  14. `orders`.`createdAt` >= "2019-01-01 00:00:00"
  15. GROUP BY `providers`.`id`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement