Problems/Coding/SQL/Easy

Easy SQL

Coding problems · 40 total

Write SELECT query to get all records

Filter records with WHERE clause

Sort results with ORDER BY

Limit results with LIMIT

Select specific columns

Use DISTINCT to remove duplicates

Filter with multiple conditions using AND/OR

Use LIKE for pattern matching

Filter NULL values with IS NULL

Use BETWEEN for range queries

Use IN clause for multiple values

Join two tables with INNER JOIN

Join tables with LEFT JOIN

Join tables with RIGHT JOIN

Use aggregate function COUNT

Use aggregate function SUM

Use aggregate function AVG

Use aggregate function MAX

Use aggregate function MIN

Group results with GROUP BY

Filter groups with HAVING

Use CASE statement for conditional logic

Concatenate strings with CONCAT

Extract date parts with DATE functions

Format dates with DATE_FORMAT

Calculate date differences

Use subquery in WHERE clause

Use EXISTS clause

Use UNION to combine results

Create table with CREATE TABLE

Insert data with INSERT INTO

Update records with UPDATE

Delete records with DELETE

Add column with ALTER TABLE

Create index with CREATE INDEX

Use COALESCE for NULL handling

Use IFNULL for NULL replacement

Calculate with mathematical functions

Use string functions (LENGTH, UPPER, LOWER)

Use ROUND for number formatting