I'm triying to add quantities of fuels from two tables. Payments table contains data about customers and dates. Fuels table contains data about fuels recharged. I need to add the litres by customer in 3 groups: from yesterday until 46…
I need to get the total price per month. I have inited_time (ex. 20160530105130) first_payment_price deleted I tried grouping by inited_time SELECT inited_time, DATE_FORMAT(inited_time, '%c') as month, SUM(first_payment_price) as price FROM some_table WHERE inited_time > 0 AND deleted = 0…
I must find the sum of the first 100 natural numbers. 1+2+3+...+n, and so on. While using "while loops". delimiter $ create procedure `calcul`.somme() begin declare s int default 0; declare i int default 1; while(i<=100) do set s :=…
How do I get the SUM of an amount in a CASE WHEN clause? Table real: id name goal year 10 ronaldo 5 2022 10 ronaldo 5 2022 11 messi 5 2022 11 messi 5 2022 10 ronaldo 10 2021…
the query bellow, unfortunately returns the wrong total of orders. What I want is to know all users whose total orders exceed the sum of their diposit. SELECT u.id, u.email,u.balance,sum(t.amount - t.fees) as total_disposits ,sum(o.charge) as spent FROM USERS u…
I'm new to SQL queries so hopes this question isn't stupid. I got two tables like this: Table 1: Name Value Count global g 1 domain x 2 domain y 1 agg ba 1 Table 2: Name Value Count global…
I have a problem and unfortunately can not find the solution! This is my database: enter image description here and I would like to store all PaymentSum(double) [PaymentInformation] in the Total (double) [Document]. This is the SQL statement: Select SUM(PaymentSum)…
After the last update of Mailster (email marketing plugin for wordpress), they have changed the way they store the information about opens, clicks, unsubscribes... Until now, everything was stored in two databases: bao_posts: Like any other wordpress post, the information…
I get an empty array when trying to get the sum of payments in decimal type column (4,2). Here's the code: global $wpdb; $balance = $wpdb->get_results("SELECT cast(sum(cpi) as decimal(5,2)) AS balance_value FROM hp_callbacks"); $row = mysqli_fetch_assoc($balance); $sum = $row['balance_value']; echo…
I'm seeking for solution on how to get count for 3 faculty code then sum all the count in one variable. I didn't found the right query to combine the count and then sum it. This is the code that…