SQL для тестировщика

Дана следующая таблица:

Books

| BookID | Title                | Author       | Genre      | PublishedYear |
|--------|----------------------|--------------|------------|---------------|
| 1      | To Kill a Mockingbird| Harper Lee   | Fiction    | 1960          |
| 2      | 1984                 | George Orwell| Fiction    | 1949          |
| 3      | The Great Gatsby     | F. Scott Fitzgerald | Fiction | 1925          |
| 4      | Pride and Prejudice  | Jane Austen  | Fiction    | 1813          |
| 5      | The Hobbit           | J.R.R. Tolkien | Fantasy  | 1937

Какой из следующих SQL запросов вернет названия книг, относящихся к жанру "Fiction", опубликованных после 1950 года?

www.tg-me.com/us/SQL для тестировщика/com.sql_for_qa/146

1.5K viewsAug 1, 2023 at 06:26

tg-me.com/sql_for_qa/146

Create: 2023-08-01
Last Update: 2025-07-02 16:09:31

Дана следующая таблица:

Books

| BookID | Title | Author | Genre | PublishedYear | |--------|----------------------|--------------|------------|---------------| | 1 | To Kill a Mockingbird| Harper Lee | Fiction | 1960 | | 2 | 1984 | George Orwell| Fiction | 1949 | | 3 | The Great Gatsby | F. Scott Fitzgerald | Fiction | 1925 | | 4 | Pride and Prejudice | Jane Austen | Fiction | 1813 | | 5 | The Hobbit | J.R.R. Tolkien | Fantasy | 1937Какой из следующих SQL запросов вернет названия книг, относящихся к жанру "Fiction", опубликованных после 1950 года?

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/146

SQL для тестировщика Telegram | DID YOU KNOW?

Telegram announces Search Filters

With the help of the Search Filters option, users can now filter search results by type. They can do that by using the new tabs: Media, Links, Files and others. Searches can be done based on the particular time period like by typing in the date or even “Yesterday”. If users type in the name of a person, group, channel or bot, an extra filter will be applied to the searches.

Telegram is riding high, adding tens of million of users this year. Now the bill is coming due.Telegram is one of the few significant social-media challengers to Facebook Inc., FB -1.90% on a trajectory toward one billion users active each month by the end of 2022, up from roughly 550 million today.