--- EXAMPLE @w3c
Select * FROM COUNT(transactions.id_transactions) AS NumberOfTrans
GROUP BY ShipperName;
----
select * COUNT(transactions.id_transactions) AS NumberOfTrans FROM transactions
GROUP by bill_to
---
SELECT items.name_item, COUNT( transactions.id_transaction ) AS NumberOfTrans,
LEFT JOIN items ON transactions.bill_to = items.id_item
FROM transactions
GROUP BY bill_to
--- PASS (sort of )
SELECT itemcategories.name_itemCategory, COUNT( transactions.id_transaction ) AS NumberOfTrans
FROM transactions
LEFT JOIN itemcategories ON transactions.bill_to = itemcategories.id_itemCategory
GROUP BY bill_to
--- PASS !!
SELECT items.name_item, COUNT( transactions.id_transaction ) AS NumberOfTrans, SUM (transactions.amount) AS Amount
FROM transactions
LEFT JOIN items ON transactions.bill_to = items.id_item
GROUP BY bill_to
--- TEST
SELECT items.name_item, COUNT( transactions.id_transaction ) AS NumberOfTrans
FROM transactions
LEFT JOIN items ON transactions.bill_to = items.id_item
GROUP BY bill_to
---TEST PASS
SELECT SUM (transactions.amount) AS amt
FROM transactions
LEFT JOIN items ON transactions.bill_to = items.id_item
GROUP BY bill_to
--- TEST PASS - edited order
SELECT items.name_item As Category, COUNT( transactions.id_transaction ) AS Transactions, SUM( transactions.amount_transaction ) AS Total,
FROM transactions
LEFT JOIN items ON transactions.bill_to = items.id_item
GROUP BY bill_to
ID: 6871
NAME: CREATE-article
DESCRIPTION: ] # # - CREATE-article# # - money update
START DATE TIME: 2017-02-01 00:27:09
EST DURATION: 01:00:00
END DATE TIME: 2017-02-01 01:27:09
STATUS: To-Do
PRIORITY: -5
OWNER ID: 1