SQL query help

[Andrejkov]

Hello,

I need help with writing a SQL query wwhich I will be able to extract from the database information on the discount codes used, but in a summed form, i.e. how much a given code has been used and what is the total sum of values of orders.

Query: SELECT * FROM `ps_order_cart_rule` returns to me the entire contents of the table, now I need to get the discount code "Your first buy" from this data and return how many times this code has been used and what is the total value of orders using this code.

Thank you very much in advance for your help.

 

[abdullacm]

SELECT name, COUNT(*) AS total_used, SUM(value) AS total_value
FROM ps_order_cart_rule
GROUP BY name

try this sql 

Edited April 27, 2022 by abdullacm
added sum of value column (see edit history)

[Andrejkov]

1 hour ago, abdullacm said:

SELECT name, COUNT(*) AS total_used, SUM(value) AS total_value
FROM ps_order_cart_rule
GROUP BY name

try this sql 

Its work perfect. Thank You. 

[Andrejkov]

2 hours ago, abdullacm said:

SELECT name, COUNT(*) AS total_used, SUM(value) AS total_value
FROM ps_order_cart_rule
GROUP BY name

try this sql 

There is other problem with  this query in column "value" i have only discount value but I need to compare this data with orders value. How i Can modify this query to get a orders value from "id_order".

[abdullacm]

SELECT c.name, COUNT(*) AS total_used, SUM(o.total_paid) AS order_total
FROM ps_order_cart_rule c
INNER JOIN ps_orders o ON(o.id_order = c.id_order)
GROUP BY c.name

 

[Andrejkov]

This is it! Thank you for yoru help 🙂