Contenido del Curso
Introduction to SQL
Introduction to SQL
Challenge: Fetching Older Books
As a librarian, a patron approaches you with an interest in older literature and requests book recommendations published in the year 1990.
Swipe to show code editor
Write a query which fetches the titles and authors of all the books that were published in the year 1990
The books table includes the columns: id, title, author, genre, publication_year, and price.
Note
In SQL, the numbers are not enclosed in quotes, unlike strings which are always enclosed in single quotes (
').
Solución
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Challenge: Fetching Older Books
As a librarian, a patron approaches you with an interest in older literature and requests book recommendations published in the year 1990.
Swipe to show code editor
Write a query which fetches the titles and authors of all the books that were published in the year 1990
The books table includes the columns: id, title, author, genre, publication_year, and price.
Note
In SQL, the numbers are not enclosed in quotes, unlike strings which are always enclosed in single quotes (
').
Solución
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones