==== SQL-lauseita ====

=== Tilauksia per tuote per vuosi ===
<code>
select name, count(name) as 'ordercount' from orderproducts where DATEPART(yyyy, received) = '2014' group by name order by 'ordercount' desc;

select name, DATEPART(yyyy, received) as 'year', count(name) as 'ordercount' from orderproducts group by name, DATEPART(yyyy, received) order by year desc, 'ordercount' desc
</code>

=== Tilaukset, tuotteet, käyttäjät (Efecten SAM-tarkistus) ===
<code>
select orders.id, orders.categoryName, orderproducts.name, orderproducts.enduserName, orders.division, orders.costpool, orders.ordered, orders.purchased, REPLACE(REPLACE(orders.comment, CHAR(13), ''), CHAR(10), '')
from orders, orderproducts
where orders.id=orderproducts.order_id
</code>