mySQL

menu table:

order_detail table:

order_main table:

Question 5 "So how have our Sunday sales (total qty and total sale:s price) for Nescafe Espresso performed over the years?" Your results should match this exactly: I 2012 I 127 I I 2011 96 I I 2010I 101 I I 2009 I 56 I I 2008 I 107 I I 2007 64I | 2006I | 2005 | I 2004 I 170 I I 2003 46I 1264.92 I 956.16I 1005.96 | 557.76 I 1065.72 I 637.44 I 49.80| 69.72 I 1693.20 I 458.16I 10 rows in set