Example Queries
Simple SELECT
Basic query to retrieve all columns from a single table
Complex JOIN
Aggregates user post counts with LEFT JOIN, filtering, grouping, and ordering
INSERT Statement
Inserts new user record with parameterized values and literals
Complex Mixed Access
Updates user activity scores based on recent posts and likes, filtering by active sessions and preferences
CREATE TABLE
Creates table with primary key, constraints, and foreign key reference
Common Table Expression
Uses CTE to filter recent posts, then joins with users for aggregation