Advertisement
AmidamaruZXC

Untitled

Dec 13th, 2020
489
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.27 KB | None | 0 0
  1. 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;
  2.  
  3. 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