Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Challenge: Help a Reader Find Their Favorite Genre | Filtering Data
Introduction to SQL
course content

Contenido del Curso

Introduction to SQL

Introduction to SQL

1. Getting Started
3. Sorting Data
4. Populating a Database
5. Updating & Deleting Data

book
Challenge: Help a Reader Find Their Favorite Genre

You are doing your job as a librarian when a reader approaches you saying they're in the mood for books from the Fantasy genre. They ask you to quickly find all the books in that category.

Tarea
test

Swipe to show code editor

Write an SQL query using the WHERE clause to find the titles of all the books where the genre is "Fantasy".

The books table includes the columns: id, title, author, genre, publication_year, and price.

Note

Strings in SQL are case-sensitive. Therefore 'fantasy' is not the same as 'Fantasy'.

Solución

Switch to desktopCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Sección 2. Capítulo 2
toggle bottom row

book
Challenge: Help a Reader Find Their Favorite Genre

You are doing your job as a librarian when a reader approaches you saying they're in the mood for books from the Fantasy genre. They ask you to quickly find all the books in that category.

Tarea
test

Swipe to show code editor

Write an SQL query using the WHERE clause to find the titles of all the books where the genre is "Fantasy".

The books table includes the columns: id, title, author, genre, publication_year, and price.

Note

Strings in SQL are case-sensitive. Therefore 'fantasy' is not the same as 'Fantasy'.

Solución

Switch to desktopCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Sección 2. Capítulo 2
Switch to desktopCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
We're sorry to hear that something went wrong. What happened?
some-alt