We need a query to generate the quantity sold and the price for each product in prestashop for each year. I can provide a database dump. We need to be able to export in excel/csv like the below example, I should be able to change the year in the query, for example to generate results for 2015, 2016 and 2017 separately.
Product | Quantity Sold | Price (CHF)
Product A | 446 | 49.95
Product B | 667 | 49.95
Product C | 553 | 49.95
Product D | 464 | 49.95
33 freelancers are bidding on average $26 for this job
Hi, I would like to write a query to get quantity sold and price. please get in touch to discuss more. Relevant Skills and Experience sql Proposed Milestones $25 USD - after completion
hi i can do your job with accuracy. i have good knowledge of sql if you interested please reply me. Relevant Skills and Experience SQL Proposed Milestones $25 USD - ..
bonjour si vous le souhaitez je peux vous faire cela de suite Cordialement Expérience et Compétences appropriées prestashop html css Étapes proposées $20 USD - export csv
. Habilidades e Experiência Relevantes I'm very experience doing queries to populate tables with more than 50 columns. Pré-pagamentos Propostos $25 USD - query