Query Builder — Student Portal Admin

Select Source

Select a table or query to start

Choose Columns

Show or hide columns from the table

π Projection

Filter Rows

Filter rows based on conditions

σ Selection

Join Table

Join with another table or query

⨝ Join / θ-Join

Append Table

Append rows from another table (UNION)

∪ Union

Group & Summarize

Group rows and aggregate with COUNT, SUM…

γ Aggregation

Add New Column

Create a computed column from expressions

Sort

Order results by column(s)

Limit / Pagination

Limit rows returned by the query

Custom SQL

Write raw SELECT query