Whether you’re a software developer, database administrator, data analyst, or data scientist, this SQL tutorial will help you unlock the power of SQL for managing and analyzing data.

This page offers printable SQL Cheat Sheet with the most commonly used SQL statements for your convenience.

In this tutorial, you will learn how to use the SQL INNER JOIN clause to merge rows from two tables based on a condition.

SELECT * FROM locations; regions SELECT * FROM regions; SQL Query Execute ClearBeautifyMinify Reload

SQL Playground is a free and interactive tool to practice SQL statements online.

In this tutorial, you'll learn about SQL subquery, a query nested within another query, to form flexible queries.

In this tutorial, you'll learn how to effectively use the SQL LEFT JOIN clause to merge rows from two or more tables.

SQL AGGREGATE FUNCTIONS AVG returns the average of a list COUNT returns the number of elements of a list SUM returns the total of a list MAX returns the maximum value in a list MIN returns …

/*Data for the table regions */ SET IDENTITY_INSERT regions ON; INSERT INTO regions(region_id,region_name) VALUES (1,'Europe'); INSERT INTO regions(region_id,region ...

CREATE TABLE regions ( region_id INT IDENTITY(1,1) PRIMARY KEY, region_name VARCHAR (25) DEFAULT NULL ); CREATE TABLE countries ( country_id CHAR (2) PRIMARY KEY, country_name …