For Colorado customers calculate the number of single products ordered. If a product is purchased on multiple orders, it should be counted only single time. The result should contain customer number, customer last name and the number of single products ordered.

Query:
select c.CUSTNO,c.CUSTFIRSTNAME,c.CUSTLASTNAME,count(ol.ORDNO) from customer c,ordertblot,ordlineol,product p where c.custno=ot.custno and ot.ordno=ol.ordno and p.PRODNO=ol.PRODNO group by  c.CUSTNO,c.CUSTFIRSTNAME,c.CUSTLASTNAME,ol.ordno;

Posted Date: 3/20/2013 7:51:27 AM | Location : United States

Ask an Expert

Related Discussions:- single products ordered, Assignment Help, Ask Question on single products ordered, Get Answer, Expert's Help, single products ordered Discussions

Write discussion on single products ordered
Your posts are moderated

Write your message here..

Related Questions

What is explicit update, What is Explicit update In explicit update,... What is Explicit update In explicit update, each derived attribute is defined with respect to one, or more fundamental base object(s). The object designer determines that de

Compare the nested-loop join and block-nested loop join, Compare the Nested... Compare the Nested-loop join and block-nested loop join Ans: Nested  loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r   where b

ANSI SPARC architecture, explain ANSI SPARC architecture explain ANSI SPARC architecture

Explain the structure of well formed formulae, Explain the structure of wel... Explain the structure of well formed formulae in relational calculus. Ans: a. An atom is a formula b. If P1 is a formula, after that so are ¬P1 and (P1) c. If P1 and P2 a

Differentiate between natural join and outer join, Differentiate between na... Differentiate between natural join and outer join? Natural join is a binary operator which is written as (R * S) where as R and S are relations. The output of the natural join

How we can implement relationships when designing tables, You want to imple... You want to implement following relationships when designing tables. How would you do it? a.) One-to-one b.) One-to-many c.) Many-to-many a.) One-to-One relationship -

Concurrency control, discuss the purpose of the concurrency control? discuss the purpose of the concurrency control?

Shadow paging, Describe the shadow paging technique. Describe the shadow paging technique.

Functional dependencies, 1. Staff (staffID --> availabilityID) 2. Servic... 1. Staff (staffID --> availabilityID) 2. Services (servicesID --> itemBasedID --> timedBasedID) 3. TimedBased (timedbasedID--> priceid) 4. Clients (clientId, serviceId-->

Explain the advantages of database management system, Advantages of Databas... Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i