Course Content
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 (
').
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your 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 (
').
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
Switch to desktop for real-world practiceContinue from where you are using one of the options below