Q. List the total of customers' orders grouped by customer (id).


Consider this table --





Answer =

Let take Customer (id) as Customer  name.

Select Customers.name , Parts.Description , Quantity from Customer , Parts where Customer.Partnum = Parts.Partnum group by Customers.name ;

25 Comments

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

  1. Yes sir I have found the tables
    Please refer to class 11 Sumita Arora

    ReplyDelete
    Replies
    1. ok , i will upload the solution very soon :)

      Delete
  2. Can you publish answers for the chapter
    Interface Python with MySQL
    Please

    ReplyDelete
  3. I will upload the solution very soon : )

    ReplyDelete
  4. Hey you have missed answer for this question...plzz upload it

    ReplyDelete
    Replies
    1. 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. Sorry I have not found customer(id) column in customers table , so I cannot write its answer : (

      If you found then please comment .

      Delete
  5. Camp.((#kjava//$445deptno))

    ReplyDelete
    Replies
    1. what you want to say , i did not understand . please comment again..

      Delete
  6. bro see solved question 17 there are the tables that you need

    ReplyDelete
  7. hey we have to take it as customer name not id

    ReplyDelete
  8. Where is 19th solution in chapter 7 querying using SQL

    ReplyDelete
  9. Great job pal :)👍

    ReplyDelete
  10. Thanks sir for helping us 🤓

    ReplyDelete
  11. man uh good job ahh!!

    ReplyDelete
  12. Can u explain this answer

    ReplyDelete

Post a Comment

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

Previous Post Next Post