Quiz di SQL: Common Table Expressions (WITH)

This SQL quiz covers common table expressions, the WITH clause that names a subquery so you can read and reuse it. You will chain CTEs, write recursive ones that count or walk a hierarchy and spot where a CTE stops existing.

Medio 10 domande ~6 minuti Superato con il 80% SQLite

Scegli una modalità

Stai giocando come ospite: accedi per salvare XP e serie.

Domanda di esempio

Domanda 1 di 10

What does this print?

CREATE TABLE orders (customer_id INTEGER, amount INTEGER);
INSERT INTO orders VALUES (1, 10), (1, 20), (2, 15), (3, 40);
WITH totals AS (
  SELECT customer_id, SUM(amount) AS total
  FROM orders
  GROUP BY customer_id
)
SELECT COUNT(*) FROM totals WHERE total > 20;
Mostra la risposta

B. 2 The CTE gives one total per customer: 30, 15 and 40. Two of them are above 20; counting the raw order rows over 20 would give 1.

Cosa copre questo quiz

  • WITH name AS (...) and chaining several CTEs
  • Column lists like WITH t(a, b) AS (...)
  • WITH RECURSIVE: anchor, recursive part and stop condition
  • Walking an employee hierarchy with depth
  • CTE scope and CTEs vs subqueries

Domande frequenti

Serve un account?

No. Chiunque può giocare. Accedi per salvare XP, serie, badge e cronologia.

Posso rifarlo?

Sì. Il tuo miglior punteggio resta salvato, e domande e risposte vengono mescolate ogni volta.