Average sql

Sql count

/*COUNT(column_name) will return the number of rows from the column 
that are not NULL*/
SELECT COUNT(column_name)
FROM table_name;

/*COUNT(*) will return the number of rows from the table*/
SELECT COUNT(*)
FROM table_name;

Sql average

SELECT student_name, avg(notes) FROM student_notes GROUP BY student_name;

How to find average in sql

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);

Similar codes

0 vote169 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote174 views2 answers
Sql query in dax power bi
SQL
0 vote166 views1 answer
Sql case when exists in another table
SQL
0 vote166 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
1 vote170 views1 answer
Sqlalchemy order by descending
SQL
2 votes172 views1 answer
Mysql add boolean column
SQL
0 vote167 views1 answer
Search db for table name
SQL
0 vote187 views1 answer
Find how many tables in database sql query
SQL
0 vote206 views1 answer
Truncate a table then insert data
SQL
27 votes193 views3 answers
Mysql show tables in database
SQL