Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT companies.company, stores.store, COUNT(users.store_id)
- FROM users
- LEFT JOIN stores
- ON users.store_id = stores.id
- LEFT JOIN companies
- ON companies.id = stores.company_id
- GROUP BY companies.company, stores.store, users.store_id
- ORDER BY companies.company DESC
Advertisement
Add Comment
Please, Sign In to add comment