Q. List the sum of the totals of orders where this sum is greater than $1000 grouped by customer (id) and state and ordered by state.


Consider  this table --



Answer =

Sorry I have not found customer(id) column in customers table , so I cannot write its answer  : (

If you found then please comment .

7 Comments

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

  1. Unknown29 June 2020 at 21:13

    U have missed this answer too

    ReplyDelete
    Replies
    1. Path Walla30 June 2020 at 19:39

      Sorry I have not found customer(id) column in customers table , so I cannot write its answer : (

      If you found then please comment . !!!!

      Delete
  2. Unknown5 January 2021 at 22:09


    J

    ReplyDelete
  3. Unknown15 April 2022 at 23:30

    Can you upload this question

    ReplyDelete
  4. Anonymous31 August 2022 at 20:45

    I think you can consider customer ID as customer name from customers, this may help (think so)

    ReplyDelete
  5. Anonymous15 June 2024 at 20:31

    SELECT C.customer_id , C.state, SUM(O.Amount) from Customers C, Orders O where C.customer_id = O.customer_id GROUP BY C.customer_id , C.state HAVING SUM(O.Amount)>1000 ORDER BY C.state;

    ReplyDelete

Post a Comment

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

Previous Post Next Post