Write sql commands to support photo applications, sales applications and reporting applications. photo applications include adding a new photo, deleting an existing photo, changing photo information, and querying photo information. sales applications include processing a sale, viewing a sale (given transactionid), finding sales (given different features e. g. date, customer name reporting application involve generating reports (e. g. find the total sales per customer).

in particular, write sql commands to support the following actions. you should be able to demonstrate the implementation of these actions.

1. list customers who spent more than 100$ for the photos.
2. list photos which were not bought.
3. list customers who bought all photos (portraits) in which a model x modeled.
4. list photographers who influenced exclusively photographers who are us citizens.
5. list photographers which took only portrait photos.
6. list transactions (transid) which contain more than 3 photos.
7. list models who modeled in all photos taken by photographer y.
8. rank the photographers by the total cost (sum of prices) of the photos they took.
9. delete from relation photo the photo with photoid=x.
10. update the photographer name of the photo with photoid=x to y.
11. compute total sales per customer 12. compute total sales per photographer sorted by photographer 13. compute total sales by photo type (portrait, landscape