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, aggregation, query optimization, indexes, explain plan

  • Number of questions

    5

  • Created on

  • Generation source

    Generated by GenOER Admin in collaboration with agent GENO 0.1A using GPT-5-mini

  • License

    CC0 Public domain

  • Prompt

    Assess ability to write and optimize SQL queries that join and aggregate data across multiple tables. Test selecting appropriate join types for given schemas, producing correct grouped results with GROUP BY and HAVING, handling NULLs and duplicate rows, applying window functions where helpful, interpreting EXPLAIN/ANALYZE output, and recommending optimizations (indexes, selective predicates, join order, avoiding unnecessary scans). Require sample queries and brief performance justifications.
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.