Challenge: Genre-Specific Movie Selection
Tarefa
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.
Solução
Tudo estava claro?
Obrigado pelo seu feedback!
Seção 3. Capítulo 2
single
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
Incrível!
Completion taxa melhorada para 4.17
Challenge: Genre-Specific Movie Selection
Deslize para mostrar o menu
Tarefa
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.
Solução
Tudo estava claro?
Obrigado pelo seu feedback!
Seção 3. Capítulo 2
single