Sales queries

Useful Info for Queries
Job IDs:


 * Sales Admin - 124
 * Safari - 111
 * Thrift Store - 16
 * Meeting Prep - 108
 * Meeting - 118
 * Thrift Store Admin - 135
 * Online Sales - 68

Worker IDs:


 * Leah - 70001
 * Ian - 53617
 * Tony - 60007
 * Paco - 50838
 * Mike - 70017
 * Luiz - 31639
 * Sergio - 34779
 * E-beth - 60002
 * Sophia - 12386

Queries
Total of Monthly XX hours logged (fill in job_id):

SELECT EXTRACT (MONTH FROM worked_shifts.date_performed) AS Monthly, SUM (duration) FROM worked_shifts WHERE date_performed BETWEEN ('2010-01-01') AND ('2010-12-31') AND job_id ='XX' GROUP BY 1 ORDER BY Monthly ASC;