Conteúdo do Curso
Introduction to SQL
Introduction to SQL
Challenge: Multiple Conditions
In the book sale, an academic researcher needs books on History that were published between 1990 and 2010, but only if they are priced at $30 or less. Compile a list that meets all these criteria.
Swipe to show code editor
Write an SQL query to fetch the titles of all books where:
- The genre is "
Historical"; - The
publication_yearis greater than or equal to 1990 and less than or equal to 2010; - The
priceis less than or equal to 30;
The book_store table includes these columns: id, title, author, genre, publication_year, and price.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
Challenge: Multiple Conditions
In the book sale, an academic researcher needs books on History that were published between 1990 and 2010, but only if they are priced at $30 or less. Compile a list that meets all these criteria.
Swipe to show code editor
Write an SQL query to fetch the titles of all books where:
- The genre is "
Historical"; - The
publication_yearis greater than or equal to 1990 and less than or equal to 2010; - The
priceis less than or equal to 30;
The book_store table includes these columns: id, title, author, genre, publication_year, and price.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo