a guest Jan 24th, 2019 66 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- select r.id route_id, COUNT(o.id) outlet_count
- from route r
- join outlet o on o.route_id = r.id
- where r.id = ?
- group by r.id;
RAW Paste Data