Re: Query writing

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 19 Dec 2013 17:16:13 +0000
Message-ID: <CABe10sbJFpnu0o8Phf4Xo7zs-Fc_K3nt-9C16qQSEdkpFnBF0A_at_mail.gmail.com>

I''ll do it for $25 per hour (admittedly you might find it takes me 5000 hours to do it :) )

On Thu, Dec 19, 2013 at 4:50 PM, Walker, Jed S <Jed_Walker_at_cable.comcast.com
> wrote:

> What is the rate per hour?
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Arif Gulzar
> *Sent:* Wednesday, December 18, 2013 1:47 PM
> *To:* oracle-l
> *Subject:* Query writing
>
>
>
> Please forward me following 2 quires. Thanks in advance.
>
>
>
>
>
> *Q1: Given the following table of transactions in a cash register:*
>
> id| trade_time | amount
>
> -- ---------------- ------
>
> 1| 06/16/2013 11:43| 52.00
>
> 2| 06/16/2013 11:50| 142.74
>
> 3| 06/16/2013 14:21| -43.89
>
> 4| 06/17/2013 12:50| 36.85
>
> 5| 06/17/2013 13:40|-523.58
>
> please write a query which selects net daily turnovers (arithmetical sums
> of all transactions for a day) for all days when these turnovers are
> positive.
>
>
>
>
>
> *Q2: Given the following two tables:*
>
>
>
> clients (id (PK), name)
>
> transactions (id (PK), client_id, trans_date, debit, credit, comment)
>
> transactions.client_id references clients.id
>
>
>
> please write a query which selects the balance for ALL clients, even if
> they have no transactions. (Assume initial balances to be zeros).
>
> Sample table contents:
>
>
>
> clients:
>
> id name
>
> -- ------
>
> 1 John
>
> 2 Mary
>
> 3 Alex
>
>
>
> transactions:
>
> id client_id trans_date debit credit comment
>
> -- --------- ---------- ------- ------- -----------------
>
> 1 | 1 06/16/2013 NULL 1000.00 SALARY
>
> 2 | 1 06/18/2013 516.43 0.00 MOB PHONE PAYMENT
>
> 3 | 2 06/16/2013 NULL 1000.00 SALARY
>
> 4 | 2 06/18/2013 200.00 NULL INTERNET PAYMENT
>
> 5 | 2 06/18/2013 500.00 0.00 MOB PHONE PAYMENT
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 19 2013 - 18:16:13 CET