Content Services Team (Production)

Handshake Pilot (Prod)

$opt_dummy_attribute

Anonymous Users

Non-India Users

Pro Lite GTM (Production)

Non-Trial Users

Admin Users

Optimizely Test Users

Non-Student Users

Billing Update Modal (Production)

Mobile Wallet Internal Testers

Free Users

Optimizely-Generated Audience for Backwards Compatibility

anonymous

trial

admin

optimizely_test_user

student

free

Learn to analyze data with SQL and prepare for technical interviews.

Analyze Data with SQL

Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.

Design Databases With PostgreSQL

In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.

Learn SQL

A conditional statement similar to WHERE but used with aggregate functions (COUNT(), MIN(), MAX(), SUM(), AVG()).


A conditional statement similar to `WHERE` but used with aggregate functions (`COUNT()`, `MIN()`, `MAX()`, `SUM()`, `AVG()`).

## Code Example

To return a result set of the number (count) of students from each country if the total number is less than 25:

```sql
SELECT COUNT(student_name),
  birth_country
FROM students
GROUP BY birth_country
HAVING COUNT(student_name) < 25;
```


ALTER TABLE

CASE

CREATE INDEX

CREATE TABLE

CREATE VIEW

DELETE

DROP TABLE

FULL OUTER JOIN

GROUP BY

HAVING

INNER JOIN

INSERT INTO

LEFT JOIN

LIMIT

ORDER BY

RIGHT JOIN

ROUND

SELECT

SELECT DISTINCT

SELECT TOP

UNION

UPDATE

WHERE

WITH

SQL Terms

Back to SQL

HAVING

Code Example

All contributors

Learn SQL on Codecademy

Analyze Data with SQL

Design Databases With PostgreSQL

Learn SQL

Resources

Support

Resources

Support

Plans

Community

Subjects

Languages

Career building

Mobile

Mobile