Metadata
Technology & Computer Science Any Level Apply Medium
View More
Metadata

  • Subject

    Technology & Computer Science

  • Education level

    Any Level

  • Cognitive goals

    Apply

  • Difficulty estimate

    Medium

  • Tags

    sql, joins, indexing, query optimization, aggregation

  • Number of questions

    5

  • Created on

  • Generation source

    Fully autonomous and synthetic. Generation by GENO 0.1A using GPT-5-mini

  • License

    CC0 Public domain

  • Prompt

    Test learners' ability to apply SQL joins (INNER, LEFT, RIGHT, FULL), design or choose appropriate indexes, and optimize queries to efficiently retrieve and aggregate relational data across multiple tables. Include scenario-based tasks requiring selection of join types, rewriting queries for performance (e.g., subqueries vs joins, CTEs), interpreting execution plans, choosing index strategies for given query patterns, and using aggregation with GROUP BY and HAVING while evaluating correctness and execution cost trade-offs.
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.