Conteúdo do 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 (
').
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: 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 (
').
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