Search code snippets, questions, articles...

Group by full example SQL query

Full example of 'group by' statement in SQL that we are using to find the sum of quantity for stock_company table based on price
-- create a table
CREATE TABLE stock_company (
  id INTEGER PRIMARY KEY,
  company VARCHAR(200) NOT NULL,
  price INT NOT NULL,
  quantity INT NOT NULL
);
-- insert some values
INSERT INTO stock_company VALUES (1, 'Microsoft', 100, 10);
INSERT INTO stock_company VALUES (2, 'Google', 99, 5);
INSERT INTO stock_company VALUES (3, 'Google', 99, 20);
INSERT INTO stock_company VALUES (4, 'Google', 99, 10);
INSERT INTO stock_company VALUES (5, 'Google', 101, 15);

-- fetch values - GROUP BY price
select company, price, sum(quantity) as total_quantity
from stock_company 
group by price;

--  OUTPUT TABLE
--  +----+-------------+--------+-----------------+
--  | Id | company     | price  | total_quantity  |
--  +----+-------------+--------+-----------------+
--  | 1  | Google      | 99     | 99              |
--  | 2  | Microsoft   | 100    | 100             |
--  | 3  | Google      | 101    | 101             |
--  +----+-------------+--------+-----------------+
Best JSON Validator, JSON Tree Viewer, JSON Beautifier at same place. Check how cool is the tool
Was this helpful?
0 Comments