Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lære Challenge: Multiple Conditions | Filtering Data
Introduction to SQL
course content

Kursusindhold

Introduction to SQL

Introduction to SQL

1. Getting Started
What is SQL?Setting Up SQL and SSMSGetting Familiar with SSMSStructure of an SQL Database SystemThe SELECT StatementChallenge: First Day as a LibrarianChallenge: Find all Book TitlesChallenge: Find Book Titles and AuthorsThe DISTINCT KeywordChallenge: Find all Genres
2. Filtering Data
The WHERE ClauseChallenge: Help a Reader Find Their Favorite GenreChallenge: Fetching Older BooksConditional Expressions: Comparison OperatorsChallenge: Avoid the Damaged BooksChallenge: Highlight New ArrivalsChallenge: Budget-Friendly BooksConditional Expressions: The AND OperatorChallenge: Find Specific Books for a ReaderChallenge: Defining RangesChallenge: Multiple ConditionsConditional Expressions: The OR OperatorChallenge: Matching Multiple OptionsChallenge: Excluding A RangeConditional Expressions: The NOT OperatorChallenge: Negating a Range
3. Sorting Data
Basic SortingChallenge: Sorting the Library CatalogueSorting by Multiple ColumnsChallenge: Further Sorting the CatalogueSorting after Filtering DataChallenge: Find the Cheapest BooksChallenge: Help a Customer Find a BookThe LIMIT KeywordChallenge: Select Books for the Collector's SectionChallenge: Affordable Books
4. Populating a Database
Creating a TableChallenge: Creating a new Books TableInserting Rows into a TableChallenge: Inserting DataChallenge: Inserting More DataInserting Multiple RowsChallenge: Inserting Bulk DataPrimary KeysThe SERIAL KeywordChallenge: Changing the Books StructureSpecifying Default ValuesChallenge: Further Improving the Books Table
5. Updating & Deleting Data
Updating Rows in a TableChallenge: Correct Book's DataChallenge: Updating Page CountsChallenge: Mark Archived Books As UnavailableDeleting RowsChallenge: Deleting Outdated RecordsDuplicating TablesChallenge: Create a Table BackupChallenge: Generate a Summarized Books TableDeleting Tables

book
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.

Opgave

Swipe to start coding

Write an SQL query to fetch the titles of all books where:

  • The genre is "Historical";
  • The publication_year is greater than or equal to 1990 and less than or equal to 2010;
  • The price is less than or equal to 30;

The book_store table includes these columns: id, title, author, genre, publication_year, and price.

Løsning

Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 2. Kapitel 11
toggle bottom row

book
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.

Opgave

Swipe to start coding

Write an SQL query to fetch the titles of all books where:

  • The genre is "Historical";
  • The publication_year is greater than or equal to 1990 and less than or equal to 2010;
  • The price is less than or equal to 30;

The book_store table includes these columns: id, title, author, genre, publication_year, and price.

Løsning

Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 2. Kapitel 11
Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Vi beklager, at noget gik galt. Hvad skete der?
some-alt