zachdyer

Store Report SQL

May 10th, 2020
1,850
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.26 KB | None | 0 0
  1. SELECT companies.company, stores.store, COUNT(users.store_id)
  2. FROM users
  3. LEFT JOIN stores
  4. ON users.store_id = stores.id
  5. LEFT JOIN companies
  6. ON companies.id = stores.company_id
  7. GROUP BY companies.company, stores.store, users.store_id
  8. ORDER BY companies.company DESC
Advertisement
Add Comment
Please, Sign In to add comment