Answer the following questions. Make sure you use comments in your SQL file to clarify/show which SQL statement is the answer to which question.

1. Write a query to show the value of each order.
2. Write a query to show the total money paid by each customer.
3. Write a query to show the total money paid by each customer per year.
4. Write a query to show the total number of orders from each customer.

orders orderumber INTEL) orderte DATE requiredte DATE shodate DATE satus TEXT comes TEXT customerfume INT(11) res customers cintomer Number INT(11) Cintomerame VARCHAR(255) contactine VARCHAR(255) contactfirme VAROWR(255) phone VARCHAR(255) address VARUR(255) addressLine2 VARCHAR(255) CHY VAROWR(255) state VAROWAR/255) postal Code VAROR(255) country VAROWA(255) sales RepEmployeumber INT(11) credit DEOMA 0:2) payments ID INT(11) customer Number INT|11) checkumber VAROHAR(255) pamerate DATE anunt DOUBLE orderdetails ID INTEIN) ordertumber INTET) product Code VARDWAR(10) quantityOrdered IN(11) priceach DOUBLE orderliner N11) products product Code VAROVAR10) productName TEXT product.ine VARD-WR(255) productScale TEXT product Vendor TEXT product Description TEXT GuantityInStock INT(11) by Price DOUBLE MSRP DOUBLE productline productLine VAROWR255) Description TEXT hem Description TEXT image TEXT offices officeCode NTCL) TEXT phone TEXT adresine TE adresine2 TEXT --- e Text curry TOT postal Code TEXT try TEXT employees employeumber INT(11) TEXT firsttime TEXT extension TEST emul TEXT officeCode INT(1) reports to TEXT jole TEXT