Kurssisisältö
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.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
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.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista