Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT f.name, COUNT(*) OVER (PARTITION BY f.food_id ORDER BY f.name) FROM Food f INNER JOIN OrderList or ON or.food_id = f.id INNER JOIN Orders o ON o.id = or.order_id;
- SELECT payment_methods, COUNT(*) FROM Customers WHERE chat_id IS NOT NULL GROUP BY payment_methods;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement