sum sql
snippet in sql

sum sql

user4932


SELECT SUM(column_name)

FROM table_name

WHERE condition; 

sum of column in sql

user336

SELECT SUM(column_name)
FROM table_name
WHERE condition;

select count sql

user7957


SELECT COUNT(column_name)

FROM table_name

WHERE condition; 

sql count

user3132

/* COUNT() is a function that takes on the name of a clomn as an argument
and counts the number of rows where the column is not null */

SELECT COUNT(column_name)
FROM table_name;

how to find averages on sql

user2737


SELECT AVG(column_name)

FROM table_name

WHERE condition; 

count sql

user6424

WHERE LOWER(FIRST_NAME || LAST_NAME)  LIKE '%d%' ;