edit-task
Home
Up
Delete
Task Name:
Task Description:
] # # - CREATE-article# # - money update
TaskGroup ID:
Start Date:
Start Time:
Duration:
Priority:
Status:
To Do
Completed
In Process
Add Photo:
Owner ID:
Content:
use HTML
Edit Content
<h1 style="text-align: center;">CREATE-article# #</h1> <h2>[previously]</h2> <ol> <li><strong>[2017-01-31][00:00] NEW task IN ?</strong></li> <ol> <li>] # # - CREATE-article# # - money -update - ] create a REPORT, transactions total by category</li> </ol> <li><strong>[00:00] NEW article IN </strong></li> <ol> <li>] # # - </li> </ol></ol> <h2>[currently]</h2> <ol> <li><strong>[00:00] NEW task IN </strong></li> <ol> <li>x] query statement for transactions, group by 'bill_to' account, </li> <li>] add WHERE param for "date" </li> </ol></ol> <h2>[next]</h2> <ol> <li>]</li> </ol> <div> <p>--- EXAMPLE @w3c </p> <p>Select * FROM COUNT(transactions.id_transactions) AS NumberOfTrans</p> <p>GROUP BY ShipperName; </p> <p>----</p> <p> </p> <p>select * COUNT(transactions.id_transactions) AS NumberOfTrans FROM transactions</p> <p>GROUP by bill_to</p> <p> </p> <p>--- </p> <p>SELECT items.name_item, COUNT( transactions.id_transaction ) AS NumberOfTrans, </p> <p>LEFT JOIN items ON transactions.bill_to = items.id_item</p> <p>FROM transactions</p> <p>GROUP BY bill_to</p> <p> </p> <p>--- PASS (sort of )</p> <p>SELECT itemcategories.name_itemCategory, COUNT( transactions.id_transaction ) AS NumberOfTrans</p> <p>FROM transactions</p> <p>LEFT JOIN itemcategories ON transactions.bill_to = itemcategories.id_itemCategory</p> <p>GROUP BY bill_to</p> <p> </p> <p>--- PASS !! </p> <p>SELECT items.name_item, COUNT( transactions.id_transaction ) AS NumberOfTrans, SUM (transactions.amount) AS Amount</p> <p>FROM transactions</p> <p>LEFT JOIN items ON transactions.bill_to = items.id_item</p> <p>GROUP BY bill_to</p> <p> </p> <p>--- TEST </p> <p>SELECT items.name_item, COUNT( transactions.id_transaction ) AS NumberOfTrans</p> <p>FROM transactions</p> <p>LEFT JOIN items ON transactions.bill_to = items.id_item</p> <p>GROUP BY bill_to</p> <p> </p> <p>---TEST PASS</p> <p>SELECT SUM (transactions.amount) AS amt</p> <p>FROM transactions</p> <p>LEFT JOIN items ON transactions.bill_to = items.id_item</p> <p>GROUP BY bill_to</p> <p> </p> <p>--- TEST PASS - edited order </p> <p>SELECT items.name_item As Category, COUNT( transactions.id_transaction ) AS Transactions, SUM( transactions.amount_transaction ) AS Total, </p> <p>FROM transactions</p> <p>LEFT JOIN items ON transactions.bill_to = items.id_item</p> <p>GROUP BY bill_to</p> <p> </p> <p> </p> </div>