Cursusinhoud
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 start coding
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.
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je 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 start coding
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.
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande opties