using sum function in mysql for two diffrenet conditions

Solutions on MaxInterview for using sum function in mysql for two diffrenet conditions by the best coders in the world

showing results for - "using sum function in mysql for two diffrenet conditions"

1
2        
3            
4        
5     SELECT 
6    SUM(CASE
7        WHEN status = 'Shipped' THEN quantityOrdered
8    END) qty_shipped,
9    SUM(CASE
10        WHEN status = 'Resolved' THEN quantityOrdered
11    END) qty_resolved,
12    SUM(CASE
13        WHEN status = 'Cancelled' THEN quantityOrdered
14    END) qty_cancelled,
15    SUM(CASE
16        WHEN status = 'On Hold' THEN quantityOrdered
17    END) qty_on_hold,
18    SUM(CASE
19        WHEN status = 'Disputed' THEN quantityOrdered
20    END) qty_on_disputed,
21    SUM(CASE
22        WHEN status = 'In Process' THEN quantityOrdered
23    END) qty_in_process
24FROM
25    orderdetails
26        INNER JOIN
27    orders USING (orderNumber);
28

1SELECT sum( mark ) FROM `student`

queries leading to this page

mysql sum of all the rows select sum of all data mysql add numbers in mysql sum 28 29 over 28 29 in mysql total sum of column in mysql sum results mysql how to sum numbers per member mysql sum of columns in mysql query mysql sum command sum of values in column mysql mysql select up to sum mysql query total sum how to sum up amounts in sql table php sum mysql column mysql count sum sum query in mysql sum mysql query php how to get sum values for column in table list mysql sum sum having myssl sum sum column mysql query mysql sum case when multiple conditions mysql sum colum mysql display as sum sum of rows mysql column sum some value to mysql column how to sum in phpmyadmin using select mysqli how to sum columns in a mysql table 3b sum of column values mysql mysql sum 28if multiple conditions 29 php sum all values in from databse mysql sum column where mysql sum whole table mysql sum of addition how to calculate the sum in mysql and display it in php sum total of columns mysqlk sum column values mysql can i pass sql statement in sum function in mysql sum column in mysql mysql sum of column used by as colum name calculating total amount given by each person in mysql mysql sum column with condition mysql calculate total how to get the sum in mysql php mysql select sum of sum sum query in mysqli including null value sum of a colum as mysql whow to sum a column mysql mysql sum 28 select sum of column in mysql mysql query to column sum how to sum variables in mysql with parameters value php to sum a column in sql mysql php sum where select total value of two products in my sql mysql column sum mysql display sum of column how to calculate additions in mysql mysql multiple column sum in node js mysql query to take sum a column mysql where with column using sum sum column mysql select sum in mysql get sum of row mysql how to sum outputs mysql sum 7 column value in mysql sum if one column in which another column is 10 mysql add total in sql query php addition in mysql mysql addition function row sum sql php mysql sum column in query result sum 28 29 in sql with mysql sum of selected cells in php sum columinmysql php table data sumation sum of multiple if statements mysql sum of one field in mysql mysql all results with sum on column addition in mysql mysql add all values of a column select one column after sum mysql print and sum all rows of data in mysql sum function mysql sum a column php mysql total values of a count 28 2a 29 how to details and sums of record in one query in mysql cretae functio to display total in mysql sb dbms sum in mysql sum value database mysql statement sum clause in mysql mysql sum mysql sum values in column sum columnsmssql php sql sum column sum of a column of result mysql mysql total mysql select total sum select sum sql php mysql sum 28 29 as how to sum rows in mysql sum of values in a column mysql mysql select all and sum columns mysql select sum of all records and with last invoice sum how to find sum in mysql sum of column in mysql calculate sum of column in mysql sum of colum msql php mysql query to get total sum of column sum row mysql mysql sum values of a column sum of a column in mysql mysql query query sum of column mysql table sum of column sum columns then rows mysql sum qty mysql different sum query in mysql find the sum of counts in mysql mysql sum column values select total value mysql php mysql sum columns select 2a sum 28 29 in mysql mysql sum function calculate sum total of all the figures in a column and save that value into databse php mysql sum of row values mysql sum select column sum distinct mysql sum where condition in mysql view table how to make summation procedue in mysql sum rows mysql mysql select sum sum as query in mysql sum in my sql select all entries and sum the total php mssql qryt to sum totla display sum finction sql value in php find the sum of count in mysql sum a column in mysql table mysql sum of select get the sum of numbers in colum mysql caculate sum of 1 column in mysql select one column from having sum mysql mysql add all values in column how to sum columns in mysql table total number column mysql how to sum columns in mysql how to sum a cloumn in mysql mysql sum one column mysql as column sum mysql 3a get the sum of each column mysql total sum sum select in mysql sum of columns in mysql get sum of column mysql mysql table column total mysql to sum all column query sum mysql sum where mysql html sum mysql column mysql total column mysql easy way to sum 2b 1 on int column mysql show the sum by item mysql sumar column mysql sum column by sum of first 25 rows mysql how to echo sum function in query in mysql sum of values in a row mysql mysql select sum of all records by bill id select ids having sum mysql how to sum sales amouts mysql mysql calculate sum mysql add total row in phpmyadmin how to sum columns from two views in mysql sum of selected column in mysql mysql sum all rows value how to get the sum of all column in a single query php mysql select up to total mysql sum row sum with conditions mysql search sum mysql mysql sum function when using row order mysql sum of different columns sum of column values in mysql sum from select mysql sum values mysql mysql sum rows summarize table mysql command sum 28 29 in mysql how to sum row values in mysql sum of all numbers in column in mysql mysql sum lines mysql select sum where summing number values in mysql database sum utwo columns in mysql sum in select statement select sum mysql mysql sum as column get the sum of a column mysql mysql calculate sum of column sum mysql column value get total amount in mysql mysql sum of columns sum of column mysql sum same row value mysql mysql query sum of column php sum 28 2a 29 over 28 29 in mysql mysql addition in select query mysql sum all columns add sum field to mysql table sum sql in php how to do all column sum in mysql search sum mysql equals group by mysql sum of amount over all select sum in mysql mysql sum function get more rows display sum of mysql row mysql suma value how to get the sum of a column in mysql write the value of my sql sum to column cal sum of columns in mysql mysql total value in column sum mysql how to sum in phpmyadmin using select wquery mysql sum with where php sum amount field in db mysql query for sum of column php mysql select sum of column search sum mysql equals mysql sum of values in a column my sql sum mysql total of column how to calculate total in mysql mysql where sum of columns columns sum in mysql get sum of value mysql php code to sum sales data column and row in mysql database mysql row of total of sum php add sum of values in a databse sum 3 sums myysql mysql get sum column mysql two tables sum return separately how to do a php select sum sum by 2 columns in mysql where sum 28column 29 mysql how to sum mysql column mysql sum of column where how to calculate 25 of total in mysql how to sum all the values in a column in mysql my sql display the sum of column how to add numbers in mysql php table colum data sumation get sum of a column in mysql selet sum mtsql how to operate addition of elements in database mysql sum function example select sum as mysql mysql php sum where between mysql sum if sum of rows values in mysql sum statement mysql sql query to sum close to given amount mysql sum of colum mssql php mysql query sum value mysql sum query mysql sum columns mysql query to get sum of column total of a field mysql sum of query in mysql sum function in mysql sum mysql distinct mysql get result sum column mysql collumn addition exoression select sum php sum a column mysql mysql sum of column mysql sum distinct sum column in mysql query mysql query select sum 3d smysql sum sum to null column in mysql how to use format 28sum 29 2c20 and case in mysql query get sum columns mysql what we call sum in mysql mysql query to sum a column how to handle sum value as null mysql how to sum numbers in database in php mysql sum all how to sum a column in mysql mysql use result of sum total mysql how to sum data into mysql table sum fuction in mysql tking database values sum mysql sumar columna get the sum of column in mysql sum database row php select sum of column mysql where to find column amount in mysql using sum function in mysql for two diffrenet conditions sum and 22 2b 22 in mysql sort the sum cases nin mysql query mysql summary fields sum in mysql command for column values mysql addition select sum of rows mysql mysql sum where mysql select sum of column mysql addition column how to sum all the data of colum i myswl mysql sum column sum of all columns mysql mysql query total sum of each column my sql sum of values through joined table sum values database php mysql msql addition sum column and select name mysql make total on query mysql find total in mysql php sum column value php query 28 27select sum 28balance 29 mysql custom column as sum how to return column sum in php mysql sum as seleect sum mysql mysql how to sum column value mysql select sum column mysql sum 1 to column select sum selects mysql php 2c mysql sum mysql sum with multiple condition get sum of column in mysql find sum of a column value in my sql mysql query sum of column mysql where on sum column sum with distinct mysql mysql addition of values sum of all columns in mysql calculating the sum of a column based on a condition in mysql sql sum column mysql do an addition in mysql sum mysql column values sum same row mysql get sum mysql mysql sum on select mysql sum of column liimt mysql sum column in result using sum function in mysql for two diffrenet conditions