---
title: "Discussion on \"Explanation and Examples of SQL Keywords and Functions.\" | Hashnode"
description: "Discussion on \"Explanation and Examples of SQL Keywords and Functions.\". Case Distinct  Group By Having IN Join Like Null Union Where  Count Avg Sum Max Min\nHere's an explanation of each keyword and a sample SQL query that demonstrates how to use them:\nAssuming you have a table named \"patients\" with columns named \"first_n..."
url: "https://hashnode.com/posts/explanation-and-examples-of-sql-keywords-and-functions/6425b3131ec60ec8ab93460b"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Explanation and Examples of SQL Keywords and Functions.](https://easycode.hashnode.dev/explanation-and-examples-of-sql-keywords-and-functions?utm_source=hashnode&utm_medium=feed)

Case Distinct Group By Having IN Join Like Null Union Where Count Avg Sum Max Min Here's an explanation of each keyword and a sample SQL query that demonstrates how to use them: Assuming you have a table named "patients" with columns named "first\_n...

Mar 30, 2023 · 5 min read · easycode.hashnode.dev  
Read the article

-   [#data-science](https://hashnode.com/tag/data-science)
-   [#sql](https://hashnode.com/tag/sql)
-   [#data-analyst](https://hashnode.com/tag/data-analyst)
-   [#business-and-finance](https://hashnode.com/tag/business-and-finance)
-   [#business-intelligence](https://hashnode.com/tag/business-intelligence)

## Written by

[Israel Ahanbare, FMVA, BIDA](https://hashnode.com/@DataBlog)

@DataBlog · Nigeria

  
[View profile](https://hashnode.com/@DataBlog)

Financial, Business Intelligence & Data Analytic Expert | Database developer | Technical Writer

My name is Israel Ahanbare, I'm an accounting graduate with a passion for business intelligence and data analysis. As a certified Financial Analyst, a certified Business Intelligence and Data Analyst. I have the skills and knowledge to help every organizations and business make informed financial Data driven decisions.

## Responses 1

Markdown supported · ⌘↵ to post

[William Hallas](https://hashnode.com/@WillHall)

[Sep 24, 2023](https://hashnode.com/posts/explanation-and-examples-of-sql-keywords-and-functions/6425b3131ec60ec8ab93460b/comment/650fffa63dd903406188bde2)

A complex subject in simple words, thank you

[Israel Ahanbare, FMVA, BIDA](https://hashnode.com/@DataBlog)

[Sep 24, 2023](https://hashnode.com/posts/explanation-and-examples-of-sql-keywords-and-functions/6425b3131ec60ec8ab93460b/comment/650fffa63dd903406188bde2#reply-6510123b3dd903406188c12f)

Glad you find it helpful. Please follow and subscribe to my newsletter where I share more amaze tips and break complex topics in simpler language.
