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
Dear,[url removed, login to view] you for reviewing me I have just read your project description carefully. I am suitable for this work and have enough power . I will provide the best product to you as you wanted. Relevant Skills and E Daha fazlası
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 - ..
I can handle this. I have 6 years experience on SQL Servers Relevant Skills and Experience SQL SERVER/MySQL Proposed Milestones $12 USD - Do the query
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