No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hello, I am trying to write an sql query in oracle that solves this question: [B]List top three customers from each state that has the most number of orders (4 points).[/B] Here is my query now that is just ranking every customer based on the # of orders they have … |
|
|
Hello, Question: List the top 25% of employees in terms of sales. Your list should include employee number, last name, first name, total number of orders, total sales. Here is what I have so far (not sure if my inner joins or even the query is totally correct): select e.employee_no, … 
|
|
|
Hey everyone! I am a student and am supposed to find some problems with this database design and eventually come up with ways how to fix them. I have listed some problems below that I have found, can someone help me with either fixes or additional problems that you see? …
|
|
|
I have these for entities and can not come up with a simple ERD. The entities are: ChairPerson, Faculty, College, Department, Certification, University, Journal, Company. I need to come up with a relational database design in Visio. I don't know what Journal or Company exactly refer to and I can …
|