Basic SQL Queries: Find Max Customers & Products Handled

[WWGD]

Hi all,
I am reviewing some material and I have been stuck on these (I am a slow starter, I guess)

1) I have the table Customer, which has an entry on sales reps for customers. I want to know which sales
rep handles the most customers. Here is what is given

Customer ( CustNum PK, CustName, RepNum,...)

Where RepNum is the sales rep that handles a given customer.

My attempt is : select repnum from customer, group by repnum having Count(RepNum) =
(select max(count(repnum)) from customer, group by repnum)

Does this work?

-------------------------------------------------------

2) I want to know which warehouse houses the most products (given by OnHand below), using the table part:

Part(PartNum, warehouse, OnHand ,... )

My attempt: select warehouse from part group by warehouse having sum(OnHand) = (select

max(sum(onHand)) from part, group by warehouse ).

Does that work?

Thanks. Sorry, My SQL is not running, so I cannot test the queries myself.

 

[fresh_42]

How urgent is it and do you have some csv test data?

 

[WWGD]

How urgent is it and do you have some csv test data?

What is csv data? I had all the answers written down on an email; I had run them (queried them) successfully, but now I cannot open it , because of useless hotmail , remember the post : https://www.physicsforums.com/threa...online-and-standard-word.853267/#post-5351041.

 

[fresh_42]

comma separated values
My experiences date back a while but I have a DB server running. To me your queries look a bit complicated, however, I do not dare to judge them. Normally I use the try and error method to fix my errors in sql statements. Guess I could try the second one right away but I have no good data on customer reps. My question on how urgent it is, is due to the fact that my sleep is (again) overdue.o
Edit: try an hex editor to open it, or 'textpad'. The latter opens everything and should be available as demo version.

 

[WWGD]

comma separated values
My experiences date back a while but I have a DB server running. To me your queries look a bit complicated, however, I do not dare to judge them. Normally I use the try and error method to fix my errors in sql statements. Guess I could try the second one right away but I have no good data on customer reps. My question on how urgent it is, is due to the fact that my sleep is (again) overdue.

Thank you, I can send you the schema as an attachment

 

[fresh_42]

https://www.textpad.com/download/

 

[jedishrfu]

If you're having trouble with your database engine, try using the H2 database engine. It's small, fast and supports most of SQL statements (not sure what it doesn't have but there's no UNION statement like DB2).

http://www.h2database.com

and SQL grammar:

http://www.h2database.com/html/grammar.html

and a tutorial on its use:

http://www.h2database.com/html/tutorial.html