SQLite SUM: Examples

Examples
Sample Database

#1

SELECT
	sum(milliseconds)
FROM
	tracks;

#2

SELECT
	albumid,
	avg(milliseconds)
FROM
	tracks
GROUP BY
	albumid;

#3

SELECT
	tracks.albumid,
	title,
	SUM(milliseconds)
FROM
	tracks
INNER JOIN albums ON albums.albumid = tracks.albumid
GROUP BY
	tracks.albumid;

#4

SELECT
	tracks.albumid,
	title,
	SUM(milliseconds)
FROM
	tracks
INNER JOIN albums ON albums.AlbumId = tracks.albumid
GROUP BY
	tracks.albumid
HAVING
	SUM(milliseconds) > 1000000;

Table List

albums

SELECT * FROM albums;

artists

SELECT * FROM artists;

customers

SELECT * FROM customers;

employees

SELECT * FROM employees;

genres

SELECT * FROM genres;

invoice_items

SELECT * FROM invoice_items;

invoices

SELECT * FROM invoices;

media_types

SELECT * FROM media_types;

playlist_track

SELECT * FROM playlist_track;

playlists

SELECT * FROM playlists;

tracks

SELECT * FROM tracks;

SQL Query

Execute

Clear Beautify Minify

Reload

Result