SQL Functions Used for the data analysis task

A Simple Guide to SQL Functions for Data Analysis! 📊✨ Explore Aggregates, Strings, and Dates with ease

A. Aggregate Functions

1. COUNT(): Returns the number of rows in a table or non-null values in a column.
Syntax:SELECT COUNT(column_name) FROM table_name;

2. SUM(): Returns the sum of values in a numeric column.
Syntax: SELECT SUM(column_name) FROM table_name;

3. AVG(): Returns the average of values in a numeric column.
Syntax:SELECT AVG(column_name) FROM table_name;

4. MIN(): Returns the minimum value in a column.
Syntax: SELECT MIN(column_name) FROM table_name;

5. MAX(): Returns the maximum value in a column.
Syntax: SELECT MAX(column_name) FROM table_name;

6. Group By(): Groups rows based on values in columns and performs aggregate functions.
Syntax: SELECT column_name, COUNT(column_name),
SUM(column_name), AVG(column_name),
MIN(column_name), MAX(column_name)
FROM table_name GROUP BY column_name;

B. String Functions

1. CONCAT(): Concatenates two or more strings.
Syntax: SELECT CONCAT(string1, string2) FROM table_name;

2. UPPER(): Converts all characters in a string to uppercase.
Syntax: SELECT UPPER(string) FROM table_name;

3. Lower(): Converts all characters in a string to lowercase.
Syntax: SELECT LOWER(string) FROM table_name;

4. Length(): Returns the length of a string.
Syntax: SELECT LENGTH(string) FROM table_name;

5. TRIM(): Removes leading or trailing spaces from a string.
Syntax: SELECT TRIM(string) FROM table_name;

6. SUBSTRING(): Extracts a substring from a larger string.
Syntax:SELECT SUBSTRING(string, start_position, length)
FROM table_name;

7. Replace(): Replaces a substring within a string with a different substring.
Syntax:SELECT REPLACE(string, old_substring, new_substring) FROM table_name;

C. Date Functions
1. GETDATE(): Returns the current date and time.
Syntax:SELECT GETDATE() FROM table_name;

2. DATEPART(): Extracts a specific part of a date (year, month, or day).
Syntax: SELECT DATEPART(part, date) FROM table_name;

3. DATEADD(): Adds a specified number of units to a date or time value.
Syntax: SELECT DATEADD(Unit, Value, Date) FROM table_name;

4. DATEDIFF(): Calculates the difference between two dates or time values.
Syntax: SELECT DATEDIFF(unit, start_date, end_date) FROM table_name;

5. YEAR(): Extracts the year from a date value.
Syntax: SELECT YEAR(date) FROM table_name;

#DataManipulation #SQLTips #Tech #DataScience #Functions #Queries #SyntaxGuide #ProgrammingTips #DataQueries #TechGuide #SQLFunctions #DataManipulation #QueryLanguage #DataSkills #keySkillset