I have this query: SELECT SUM(CASE WHEN color = ‘blue’ THEN 1 ELSE 0 END) AS “Blue”, SUM(CASE WHEN color = ‘purple’ THEN 1 ELSE 0 END) AS “Purple”, SUM(CASE WHEN color = ‘yellow’ THEN 1 …
Tag: sum
SQL Query rounding issue
I am using pyodbc to fetch total quantity of a product based on a certain criteria called “Strength”. The “Strength” column also has string value for some records, so it is a varchar column. The user enters details like brand, product type, product line, date range, minimum quantity (i…
SQL Joining of Multiple Tables
SQL newbie here, I am trying to have the table print out the sum of the wages, make, and car model for all the people that own a particular make/model combination. As of right now, the table prints …
MySQL query – join 4 tables together, with 3 tables using group by one column from each
Here are examples of the 4 tables I’m working with. And I’m trying to get outputs with php foreach something like this … This is the query I’ve come for one table… Answer You can cross join the items table with all available dates in the three other tables, and then the aggregati…
Using sum with multiple dates but keeping only the latest date
I have a table called Prospect that looks like this and I’m trying to SUM the value so that I have only 1 column for GEORGIA, ALABAMA,TEXAS and the date kept in the date field be the latest date entry. I would like to have a resultset that looks like this This is what I’ve tried, but it is not
MySQL query to sum one column and count another column, from two tables, based on a common value?
I’m having issues getting my head around a query that I am trying to build. I’m hoping for a bit of help here… I have two tables. Each table has two columns. They are described as follows: Table: “Token” Table: “Score” I want a query that will list each name once, and…
Combining some of the rows and sum them up in oracle sql
I`m working on some data manipulation and have table: I need to have and output to look like: Please suggest what can I use to combine and sum up those. I appreciate any input! Thank you Answer You can use aggregation. Values are strings, so you probably want to concatenate them rather than sum them (which ma…
Sum rows not in the top x rows of a group in the table into an “other” row?
If I have a table like the following which is the number of records with a given label grouped by a certain category (in this case Male, Female), How would I transform it into a table that keeps the top x (e.g. 5 records) for each category, when the rows are sorted by number descending, and sums the remaining…
While display group of table value in mysql it shows each and every value as ‘0’
my table and it’s values are Now, i am going to grouping table but returns value in 0 While group the table it returns each and every column value returns in 0. Why that is happened. I need present or absent instead of 0. Can anyone solve this logic error? Answer sum(case when hour = ‘P1’ th…
SQL – Generate column from sum of columns from different table
I have two tables: The first one contains numeral values, it looks like this: The id column is the primary key; it has the attribute AUTO_INCREMENT. All columns have the datatype INT. Now my …