Challenge: Genre-Specific Movie Selection
Compito
Swipe to start coding
Write a query to select all columns from the movies table, but only include rows that meet the following genre-specific criteria:
- If the genre is 'Action', the rating must be greater than or equal to 7.
- If the genre is 'Comedy', the rating must be greater than or equal to 6.
- For all other genres, the rating must be greater than or equal to 8.
Soluzione
Tutto è chiaro?
Grazie per i tuoi commenti!
Sezione 3. Capitolo 2
single
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
Fantastico!
Completion tasso migliorato a 4.17
Challenge: Genre-Specific Movie Selection
Scorri per mostrare il menu
Compito
Swipe to start coding
Write a query to select all columns from the movies table, but only include rows that meet the following genre-specific criteria:
- If the genre is 'Action', the rating must be greater than or equal to 7.
- If the genre is 'Comedy', the rating must be greater than or equal to 6.
- For all other genres, the rating must be greater than or equal to 8.
Soluzione
Tutto è chiaro?
Grazie per i tuoi commenti!
Sezione 3. Capitolo 2
single