Path: text.usenetserver.com!out01a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!80g2000cwy.googlegroups.com!not-for-mail
From: "vishnu" <settyv@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Help on query
Date: 12 Dec 2006 14:20:07 -0800
Organization: http://groups.google.com
Lines: 27
Message-ID: <1165962006.964669.26780@80g2000cwy.googlegroups.com>
NNTP-Posting-Host: 144.160.98.31
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1165962013 22526 127.0.0.1 (12 Dec 2006 22:20:13 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 22:20:13 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 80g2000cwy.googlegroups.com; posting-host=144.160.98.31;
   posting-account=nPur-Q0AAAABaXX8UJlTTYJxcj8V5lXp
Xref: usenetserver.com comp.databases.oracle.server:419068
X-Received-Date: Tue, 12 Dec 2006 17:20:13 EST (text.usenetserver.com)

Table Structure will be like this.
Hi,

 I need to write Oracle query for this.Please help to solve this.

Case ID, Major Type, Requested Date

We need to find the count of cases which are over due, due today,
between 7-14 days etc as shown in the table.
Based on comparison between sysdate and requested date.

Can this requirement fit into a query. ?


Case Summary
Major           Over Due        Due Today       Due Next 7-14 Days
Due Next 15-30 Days     Due Over 30 Days
Delivery                0       0       4       0       0
Return          0       0       0       0       0
Service         0       0       0       0       0
Relocation              0       0       0       0       0
Water Intrusion         0       0       0       0       0


Thanks,
Vishnu