Write a SQL query to show all users who placed orders more than two times. I have
Fantastic news! We've Found the answer you've been seeking!
Question:
Write a SQL query to show all users who placed orders more than two times.
I have a database called database_1
In database_1 there is the following:
Orders(order_id(Primary, int), registered_date(date), user_id(MUL, int)
OrdersProducts(order_id(Primary, int), price(float), product_id(Primary, int), quantity(int)
Ratings(order_id(Primary, int), product_id(Primary, int), rate(int), comment(VARCHAR)
Users(email(UNIQUE, VARCHAR), name(VARCHAR), password(VARCHAR), registered_date(date), username(UNIQUE, VARCHAR), user_id(Primary, int)
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date: