The OP's blog <http://arifgulzar.blogspot.com/> does carry the title "Productivity Freak"; nice to see truth in advertising.
On 12/19/2013 9:50 AM, Walker, Jed S wrote:
What is the rate per hour?*From:*oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] *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.58please 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 <http://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
