Task: NL2SQL (source dataset: bird)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Database:
card_games

Tables:

Table: cards
|   id | artist                        | asciiName   | availability   | borderColor   | cardKingdomFoilId   | cardKingdomId   | colorIdentity   | colorIndicator   | colors   |   convertedManaCost | duelDeck   |   edhrecRank | faceConvertedManaCost   | faceName   | flavorName   | flavorText                                                                                                   | frameEffects   |   frameVersion | hand   |   hasAlternativeDeckLimit |   hasContentWarning |   hasFoil |   hasNonFoil |   isAlternative |   isFullArt |   isOnlineOnly |   isOversized |   isPromo |   isReprint |   isReserved |   isStarter |   isStorySpotlight |   isTextless |   isTimeshifted | keywords           | layout   | leadershipSkills                                          | life   | loyalty   | manaCost   |   mcmId |   mcmMetaId | mtgArenaId   | mtgjsonV4Id                          | mtgoFoilId   | mtgoId   | multiverseId   | name                     | number   | originalReleaseDate   | originalText                                                                                                          | originalType                     | otherFaceIds   | power   | printings                                             | promoTypes   | purchaseUrls                                                                                                                                                                                                                                          | rarity   | scryfallId                           | scryfallIllustrationId               | scryfallOracleId                     | setCode   | side   | subtypes     | supertypes   |   tcgplayerProductId | text                                                                                                                  | toughness   | type                             | types    | uuid                                 | variations                           | watermark   |
|-----:|:------------------------------|:------------|:---------------|:--------------|:--------------------|:----------------|:----------------|:-----------------|:---------|--------------------:|:-----------|-------------:|:------------------------|:-----------|:-------------|:-------------------------------------------------------------------------------------------------------------|:---------------|---------------:|:-------|--------------------------:|--------------------:|----------:|-------------:|----------------:|------------:|---------------:|--------------:|----------:|------------:|-------------:|------------:|-------------------:|-------------:|----------------:|:-------------------|:---------|:----------------------------------------------------------|:-------|:----------|:-----------|--------:|------------:|:-------------|:-------------------------------------|:-------------|:---------|:---------------|:-------------------------|:---------|:----------------------|:----------------------------------------------------------------------------------------------------------------------|:---------------------------------|:---------------|:--------|:------------------------------------------------------|:-------------|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:---------|:-------------------------------------|:-------------------------------------|:-------------------------------------|:----------|:-------|:-------------|:-------------|---------------------:|:----------------------------------------------------------------------------------------------------------------------|:------------|:---------------------------------|:---------|:-------------------------------------|:-------------------------------------|:------------|
|    1 | Pete Venters                  |             | mtgo,paper     | black         |                     | 122719          | W               |                  | W        |                   7 |            |        15650 |                         |            |              |                                                                                                              |                |           2003 |        |                         0 |                   0 |         0 |            1 |               0 |           0 |              0 |             0 |         0 |           1 |            0 |           0 |                  0 |            0 |               0 | First strike       | normal   |                                                           |        |           | {5}{W}{W}  |   16165 |         156 |              | ad41be73-582f-58ed-abd4-a88c1f616ac3 | 27501        | 27500    | 130550         | Ancestor's Chosen        | 1        |                       | First strike (This creature deals combat damage before creatures without first strike.)                               | Creature - Human Cleric          |                | 4       | 10E,JUD,UMA                                           |              | {'cardKingdom': 'https://mtgjson.com/links/9fb51af0ad6f0736', 'cardmarket': 'https://mtgjson.com/links/ace8861194ee0b6a', 'tcgplayer': 'https://mtgjson.com/links/4843cea124a0d515'}                                                                  | uncommon | 7a5cd03c-4227-4551-aa4b-7d119f0468b5 | be2f7173-c8b7-4172-a388-9b2c6b3c16e5 | fc2ccab7-cab1-4463-b73d-898070136d74 | 10E       |        | Human,Cleric |              |                15032 | First strike (This creature deals combat damage before creatures without first strike.)                               | 4           | Creature — Human Cleric          | Creature | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c | b7c19924-b4bf-56fc-aa73-f586e940bd42 |             |
|      |                               |             |                |               |                     |                 |                 |                  |          |                     |            |              |                         |            |              |                                                                                                              |                |                |        |                           |                     |           |              |                 |             |                |               |           |             |              |             |                    |              |                 |                    |          |                                                           |        |           |            |         |             |              |                                      |              |          |                |                          |          |                       | When Ancestor's Chosen comes into play, you gain 1 life for each card in your graveyard.                              |                                  |                |         |                                                       |              |                                                                                                                                                                                                                                                       |          |                                      |                                      |                                      |           |        |              |              |                      | When Ancestor's Chosen enters the battlefield, you gain 1 life for each card in your graveyard.                       |             |                                  |          |                                      |                                      |             |
|    2 | Volkan Baǵa                   |             | mtgo,paper     | black         |                     | 122720          | W               |                  | W        |                   5 |            |        12702 |                         |            |              | Every tear shed is a drop of immortality.                                                                    |                |           2003 |        |                         0 |                   0 |         0 |            1 |               0 |           0 |              0 |             0 |         0 |           1 |            0 |           0 |                  0 |            0 |               0 | Flying             | normal   |                                                           |        |           | {4}{W}     |   16166 |         176 |              | 9eb2e54c-a12b-5e88-a9c0-d8c84c52d59c | 26993        | 26992    | 129465         | Angel of Mercy           | 2        |                       | Flying (This creature can't be blocked except by creatures with flying or reach.)                                     | Creature - Angel                 |                | 3       | 10E,8ED,9ED,DDC,DVD,IMA,INV,JMP,MB1,P02,PS11,PSAL,S99 |              | {'cardKingdom': 'https://mtgjson.com/links/027095d094e58f5b', 'cardmarket': 'https://mtgjson.com/links/f6fb5098e1cd1b1e', 'tcgplayer': 'https://mtgjson.com/links/56c4b57293f350ef'}                                                                  | uncommon | 8f7980d4-da43-4d6d-ad16-14b8a34ae91d | e4d6c53f-e936-4be8-8b70-47c2be863b20 | a2daaf32-dbfe-4618-892e-0da24f63a44a | 10E       |        | Angel        |              |                15033 | Flying                                                                                                                | 3           | Creature — Angel                 | Creature | 57aaebc1-850c-503d-9f6e-bb8d00d8bf7c | 8fd4e2eb-3eb4-50ea-856b-ef638fa47f8a |             |
|      |                               |             |                |               |                     |                 |                 |                  |          |                     |            |              |                         |            |              |                                                                                                              |                |                |        |                           |                     |           |              |                 |             |                |               |           |             |              |             |                    |              |                 |                    |          |                                                           |        |           |            |         |             |              |                                      |              |          |                |                          |          |                       | When Angel of Mercy comes into play, you gain 3 life.                                                                 |                                  |                |         |                                                       |              |                                                                                                                                                                                                                                                       |          |                                      |                                      |                                      |           |        |              |              |                      | When Angel of Mercy enters the battlefield, you gain 3 life.                                                          |             |                                  |          |                                      |                                      |             |
|    3 | Justin Sweet                  |             | mtgo,paper     | black         |                     | 122725          | W               |                  | W        |                   4 |            |        11081 |                         |            |              |                                                                                                              |                |           2003 |        |                         0 |                   0 |         0 |            1 |               0 |           0 |              0 |             0 |         0 |           1 |            0 |           0 |                  0 |            0 |               0 | Flying             | normal   |                                                           |        |           | {3}{W}     |   16171 |         368 |              | c0de6fd8-367a-50fb-b2f4-2b8fa5aeb7d9 | 27473        | 27472    | 129470         | Aven Cloudchaser         | 7        |                       | Flying (This creature can't be blocked except by creatures with flying or reach.)                                     | Creature - Bird Soldier          |                | 2       | 10E,8ED,9ED,ODY                                       |              | {'cardKingdom': 'https://mtgjson.com/links/9246105d88032a9f', 'cardmarket': 'https://mtgjson.com/links/dcdfe48e6a8f9e1e', 'tcgplayer': 'https://mtgjson.com/links/3ce595aabe276f80'}                                                                  | common   | 407110e9-19af-4ff5-97b2-c03225031a73 | 2eb663cd-020a-46d8-a6d9-bb63d4b5c848 | 48bda7dd-d023-41e8-8c28-e0cfda0d07ca | 10E       |        | Bird,Soldier |              |                15045 | Flying (This creature can't be blocked except by creatures with flying or reach.)                                     | 2           | Creature — Bird Soldier          | Creature | 8ac972b5-9f6e-5cc8-91c3-b9a40a98232e | 6adaf14d-43e3-521a-adf1-960c808e5b1a |             |
|      |                               |             |                |               |                     |                 |                 |                  |          |                     |            |              |                         |            |              |                                                                                                              |                |                |        |                           |                     |           |              |                 |             |                |               |           |             |              |             |                    |              |                 |                    |          |                                                           |        |           |            |         |             |              |                                      |              |          |                |                          |          |                       | When Aven Cloudchaser comes into play, destroy target enchantment.                                                    |                                  |                |         |                                                       |              |                                                                                                                                                                                                                                                       |          |                                      |                                      |                                      |           |        |              |              |                      | When Aven Cloudchaser enters the battlefield, destroy target enchantment.                                             |             |                                  |          |                                      |                                      |             |
|    4 | Matthew D. Wilson             |             | mtgo,paper     | black         | 123094              | 122726          | W               |                  | W        |                   4 |            |        12901 |                         |            |              | The perfect antidote for a tightly packed formation.                                                         |                |           2003 |        |                         0 |                   0 |         1 |            1 |               0 |           0 |              0 |             0 |         0 |           1 |            0 |           0 |                  0 |            0 |               0 |                    | normal   |                                                           |        |           | {3}{W}     |   16172 |         423 |              | bfbb65b1-f1bb-5355-9495-fb094f9b0782 | 27327        | 27326    | 129477         | Ballista Squad           | 8        |                       | {X}{W}, {T}: Ballista Squad deals X damage to target attacking or blocking creature.                                  | Creature - Human Rebel           |                | 2       | 10E,9ED,MMQ                                           |              | {'cardKingdom': 'https://mtgjson.com/links/d702da7661073a13', 'cardKingdomFoil': 'https://mtgjson.com/links/fbb773ed07f117ac', 'cardmarket': 'https://mtgjson.com/links/f04d4a0c97f986fe', 'tcgplayer': 'https://mtgjson.com/links/1e6874adc6cbd28f'} | uncommon | a4d17394-b9c4-43f6-9a6d-2c7c7ecb1d74 | 8464353d-099c-47ba-a0eb-e08b7b76b464 | 5973725c-6e1f-4d7e-bcef-3d867ea4c244 | 10E       |        | Human,Rebel  |              |                15048 | {X}{W}, {T}: Ballista Squad deals X damage to target attacking or blocking creature.                                  | 2           | Creature — Human Rebel           | Creature | a69b404f-144a-5317-b10e-7d9dce135b24 |                                      |             |
|    5 | Rebecca Guay                  |             | mtgo,paper     | black         | 123095              | 122727          | W               |                  | W        |                   1 |            |         3988 |                         |            |              | Life is measured in inches. To a healer, every one of those inches is precious.                              |                |           2003 |        |                         0 |                   0 |         1 |            1 |               0 |           0 |              0 |             0 |         0 |           1 |            0 |           0 |                  0 |            0 |               0 |                    | normal   |                                                           |        |           | {W}        |   16173 |         432 |              | a634f6df-fd74-54d9-a56c-3fdd2ad3e9bf | 27095        | 27094    | 132106         | Bandage                  | 9        |                       | Prevent the next 1 damage that would be dealt to target creature or player this turn.                                 | Instant                          |                |         | 10E,STH,TPR                                           |              | {'cardKingdom': 'https://mtgjson.com/links/a072a876146b29bc', 'cardKingdomFoil': 'https://mtgjson.com/links/30995197ba8fc8c1', 'cardmarket': 'https://mtgjson.com/links/35a66170a09a59c7', 'tcgplayer': 'https://mtgjson.com/links/d091fd8b400df945'} | common   | c9c17e3b-4d7f-4472-afe1-8e9358b82f2c | af3d1d9e-8a04-4ba5-aa96-9ea678daaa2b | c664df64-0103-462b-a0f8-c483b152974a | 10E       |        |              |              |                15049 | Prevent the next 1 damage that would be dealt to any target this turn.                                                |             | Instant                          | Instant  | 6d268c95-c176-5766-9a46-c14f739aba1c |                                      |             |
|      |                               |             |                |               |                     |                 |                 |                  |          |                     |            |              |                         |            |              |                                                                                                              |                |                |        |                           |                     |           |              |                 |             |                |               |           |             |              |             |                    |              |                 |                    |          |                                                           |        |           |            |         |             |              |                                      |              |          |                |                          |          |                       | Draw a card.                                                                                                          |                                  |                |         |                                                       |              |                                                                                                                                                                                                                                                       |          |                                      |                                      |                                      |           |        |              |              |                      | Draw a card.                                                                                                          |             |                                  |          |                                      |                                      |             |
|    6 | Rob Alexander                 |             | mtgo,paper     | black         | 123096              | 122728          | W               |                  | W        |                   6 |            |         2801 |                         |            |              | The cave floods with light. A thousand rays shine forth and meld into one.                                   |                |           2003 |        |                         0 |                   0 |         1 |            1 |               0 |           0 |              0 |             0 |         0 |           1 |            0 |           0 |                  0 |            0 |               0 |                    | normal   |                                                           |        |           | {5}{W}     |   16174 |         499 |              | 43f8222f-3fd5-5491-9e76-5b1cc9a86e93 | 27622        | 27621    | 130553         | Beacon of Immortality    | 10       |                       | Double target player's life total. Shuffle Beacon of Immortality into its owner's library.                            | Instant                          |                |         | 10E,5DN,E02,MB1                                       |              | {'cardKingdom': 'https://mtgjson.com/links/641aecf0d3150e1f', 'cardKingdomFoil': 'https://mtgjson.com/links/8aaf9f7f17f79315', 'cardmarket': 'https://mtgjson.com/links/8919bf4f1f651197', 'tcgplayer': 'https://mtgjson.com/links/04830bb89a273674'} | rare     | f0b9b5da-d3fa-4d70-a71a-a2342dbfd527 | e314cc4f-55dc-48c5-abb3-2aa78e940020 | bfcdf563-c6e5-4a54-bb63-4aba219b94e2 | 10E       |        |              |              |                15052 | Double target player's life total. Shuffle Beacon of Immortality into its owner's library.                            |             | Instant                          | Instant  | 56f4935b-f6c5-59b9-88bf-9bcce20247ce |                                      |             |
|    7 | Zoltan Boros & Gabor Szikszai |             | mtgo,paper     | black         |                     | 122729          | W               |                  | W        |                   3 |            |        12902 |                         |            |              | "We called them 'armored lightning.'"                                                                        |                |           2003 |        |                         0 |                   0 |         0 |            1 |               0 |           0 |              0 |             0 |         0 |           1 |            0 |           0 |                  0 |            0 |               0 | First strike,Flash | normal   |                                                           |        |           | {2}{W}     |   16175 |         520 |              | 1c5f900e-982d-5c65-89fd-46dd4db76716 | 27217        | 27216    | 136279         | Benalish Knight          | 11       |                       | Flash (You may play this spell any time you could play an instant.)                                                   | Creature - Human Knight          |                | 2       | 10E,ATH,WTH                                           |              | {'cardKingdom': 'https://mtgjson.com/links/d9c713a9894e9d63', 'cardmarket': 'https://mtgjson.com/links/654c1a3a20333a30', 'tcgplayer': 'https://mtgjson.com/links/2fbe5cd35119ca23'}                                                                  | common   | d0ae60d0-20d3-452c-9953-e229567c06f5 | 52e78c38-9de7-465b-9ef6-db8b4c857409 | 32b401e9-163f-4917-a728-fc63b25ef602 | 10E       |        | Human,Knight |              |                15054 | Flash (You may cast this spell any time you could cast an instant.)                                                   | 2           | Creature — Human Knight          | Creature | 62365fbb-af07-5c2a-976d-e3092bdfc317 | 0d2a4e1d-cc12-5675-8044-9a7bc7d60050 |             |
|      |                               |             |                |               |                     |                 |                 |                  |          |                     |            |              |                         |            |              | —Gerrard of the *Weatherlight*                                                                               |                |                |        |                           |                     |           |              |                 |             |                |               |           |             |              |             |                    |              |                 |                    |          |                                                           |        |           |            |         |             |              |                                      |              |          |                |                          |          |                       | First strike (This creature deals combat damage before creatures without first strike.)                               |                                  |                |         |                                                       |              |                                                                                                                                                                                                                                                       |          |                                      |                                      |                                      |           |        |              |              |                      | First strike (This creature deals combat damage before creatures without first strike.)                               |             |                                  |          |                                      |                                      |             |
|    8 | Zoltan Boros & Gabor Szikszai |             | mtgo,paper     | black         | 123097              |                 | W               |                  | W        |                   3 |            |        12902 |                         |            |              | "We called them 'armored lightning.'"                                                                        |                |           2003 |        |                         0 |                   0 |         1 |            0 |               1 |           0 |              0 |             0 |         0 |           1 |            0 |           0 |                  0 |            0 |               0 | First strike,Flash | normal   |                                                           |        |           | {2}{W}     |   16175 |         520 |              | 50eac642-2fda-5f35-a5fc-6f6e10c3ee85 |              |          |                | Benalish Knight          | 11★      |                       |                                                                                                                       |                                  |                | 2       | 10E,ATH,WTH                                           |              | {'cardKingdomFoil': 'https://mtgjson.com/links/f1e4d8ed22a75d81', 'cardmarket': 'https://mtgjson.com/links/e29a1f7888edb9c9', 'tcgplayer': 'https://mtgjson.com/links/2f94fec978473fbf'}                                                              | common   | bccebfdd-85cb-4549-93a4-c0dcd667ee04 | 52e78c38-9de7-465b-9ef6-db8b4c857409 | 32b401e9-163f-4917-a728-fc63b25ef602 | 10E       |        | Human,Knight |              |                15054 | Flash (You may cast this spell any time you could cast an instant.)                                                   | 2           | Creature — Human Knight          | Creature | 0d2a4e1d-cc12-5675-8044-9a7bc7d60050 | 62365fbb-af07-5c2a-976d-e3092bdfc317 |             |
|      |                               |             |                |               |                     |                 |                 |                  |          |                     |            |              |                         |            |              | —Gerrard of the *Weatherlight*                                                                               |                |                |        |                           |                     |           |              |                 |             |                |               |           |             |              |             |                    |              |                 |                    |          |                                                           |        |           |            |         |             |              |                                      |              |          |                |                          |          |                       |                                                                                                                       |                                  |                |         |                                                       |              |                                                                                                                                                                                                                                                       |          |                                      |                                      |                                      |           |        |              |              |                      | First strike (This creature deals combat damage before creatures without first strike.)                               |             |                                  |          |                                      |                                      |             |
|    9 | Steven Belledin               |             | mtgo,paper     | black         | 123098              | 122730          | W               |                  | W        |                   4 |            |        10053 |                         |            |              | "Mercadia's masks can no longer hide the truth. Our day has come at last."                                   |                |           2003 |        |                         0 |                   0 |         1 |            1 |               0 |           0 |              0 |             0 |         0 |           1 |            0 |           0 |                  0 |            0 |               0 |                    | normal   | {'brawl': False, 'commander': True, 'oathbreaker': False} |        |           | {2}{W}{W}  |   16176 |         971 |              | 8f6bfe34-f704-5ac8-a025-921a0276bb54 | 27187        | 27186    | 130554         | Cho-Manno, Revolutionary | 12       |                       | Prevent all damage that would be dealt to Cho-Manno, Revolutionary.                                                   | Legendary Creature - Human Rebel |                | 2       | 10E,MMQ,PS11                                          |              | {'cardKingdom': 'https://mtgjson.com/links/8b23ca3e6a53519c', 'cardKingdomFoil': 'https://mtgjson.com/links/5fa521ab3f994840', 'cardmarket': 'https://mtgjson.com/links/b1acf2fb171a5d2e', 'tcgplayer': 'https://mtgjson.com/links/be0135925ca66ebf'} | rare     | fe04dfe7-6376-4c12-9404-0e1ae0942917 | 443c01cf-c337-4b68-9a0a-cd39a3e103f5 | 91af5e35-b3b8-43ce-b1ea-997ed74e4ad2 | 10E       |        | Human,Rebel  | Legendary    |                15070 | Prevent all damage that would be dealt to Cho-Manno, Revolutionary.                                                   | 2           | Legendary Creature — Human Rebel | Creature | 81daea6a-2735-5a46-a2da-b65a2ad5738f |                                      |             |
|   10 | Daren Bader                   |             | mtgo,paper     | black         | 123099              | 122731          | W               |                  | W        |                   1 |            |         1900 |                         |            |              | "No doubt the arbiters would put you away, after all the documents are signed. But I will have justice now!" |                |           2003 |        |                         0 |                   0 |         1 |            1 |               0 |           0 |              0 |             0 |         0 |           1 |            0 |           0 |                  0 |            0 |               0 |                    | normal   |                                                           |        |           | {W}        |   16177 |        7562 |              | 42b053db-3d18-5e1a-b4c8-c39233ad9afe | 27740        | 27739    | 130528         | Condemn                  | 13       |                       | Put target attacking creature on the bottom of its owner's library. Its controller gains life equal to its toughness. | Instant                          |                |         | 10E,C14,C17,CMR,DDL,DIS,M11,P07,PRM,PS11,TD0,TD2,ZNC  |              | {'cardKingdom': 'https://mtgjson.com/links/d17930d5637c1e89', 'cardKingdomFoil': 'https://mtgjson.com/links/7e0b1c1e656fc86d', 'cardmarket': 'https://mtgjson.com/links/af7c4f7223ac32ec', 'tcgplayer': 'https://mtgjson.com/links/7f98bb25bbd3aba2'} | uncommon | ea9edff0-58a8-405d-9f2e-39f8269bbcb2 | 57c58043-4790-4852-82e3-09efb42d7803 | 377d31b5-0a48-4d5b-91bd-b5a62d4f7899 | 10E       |        |              |              |                15081 | Put target attacking creature on the bottom of its owner's library. Its controller gains life equal to its toughness. |             | Instant                          | Instant  | 7fef665c-36a1-5f7a-9299-cf8938708710 |                                      |             |
|      |                               |             |                |               |                     |                 |                 |                  |          |                     |            |              |                         |            |              | —Alovnek, Boros guildmage                                                                                    |                |                |        |                           |                     |           |              |                 |             |                |               |           |             |              |             |                    |              |                 |                    |          |                                                           |        |           |            |         |             |              |                                      |              |          |                |                          |          |                       |                                                                                                                       |                                  |                |         |                                                       |              |                                                                                                                                                                                                                                                       |          |                                      |                                      |                                      |           |        |              |              |                      |                                                                                                                       |             |                                  |          |                                      |                                      |             |


Table: foreign_data
|   id | flavorText                                                  | language            |   multiverseid | name                     | text                                                                                                                | type                            | uuid                                 |
|-----:|:------------------------------------------------------------|:--------------------|---------------:|:-------------------------|:--------------------------------------------------------------------------------------------------------------------|:--------------------------------|:-------------------------------------|
|    1 | „Es ist der Wille aller, und meine Hand, die ihn ausführt." | German              |         148411 | Ausgewählter der Ahnfrau | Erstschlag (Diese Kreatur fügt Kampfschaden vor Kreaturen ohne Erstschlag zu.)                                      | Kreatur — Mensch, Kleriker      | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|      |                                                             |                     |                |                          | Wenn der Ausgewählte der Ahnfrau ins Spiel kommt, erhältst du 1 Lebenspunkt für jede Karte in deinem Friedhof dazu. |                                 |                                      |
|    2 | "La voluntad de todos, realizada por mi mano."              | Spanish             |         150317 | Elegido de la Antepasada | Daña primero. (Esta criatura hace daño de combate antes que las criaturas sin la habilidad de dañar primero.)       | Criatura — Clérigo humano       | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|      |                                                             |                     |                |                          | Cuando el Elegido de la Antepasada entre en juego, ganas 1 vida por cada carta en tu cementerio.                    |                                 |                                      |
|    3 | « La volonté de tous passe par ma main. »                   | French              |         149934 | Élu de l'Ancêtre         | Initiative (Cette créature inflige des blessures de combat avant les créatures sans l'initiative.)                  | Créature : humain et clerc      | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|      |                                                             |                     |                |                          | Quand l'Élu de l'Ancêtre arrive en jeu, vous gagnez 1 point de vie pour chaque carte dans votre cimetière.          |                                 |                                      |
|    4 | "La volontà di tutti, eseguita per mano mia."               | Italian             |         148794 | Prescelto dell'Antenata  | Attacco improvviso (Questa creatura infligge danno da combattimento prima delle creature senza attacco improvviso.) | Creatura — Chierico Umano       | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|      |                                                             |                     |                |                          | Quando il Prescelto dell'Antenata entra in gioco, guadagni 1 punto vita per ogni carta nel tuo cimitero.            |                                 |                                      |
|    5 | すべての意思を、この手で成そう。                            | Japanese            |         148028 | 祖神に選ばれし者         | 先制攻撃 （このクリーチャーは先制攻撃を持たないクリーチャーよりも先に戦闘ダメージを与える。）                       | クリーチャー — 人間・クレリック | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|      |                                                             |                     |                |                          | 祖神に選ばれし者が場に出たとき、あなたはあなたの墓地にあるカード１枚につき１点のライフを得る。                      |                                 |                                      |
|    6 | "A vontade de todos pelas minhas mãos realizada."           | Portuguese (Brazil) |         149551 | Eleito da Ancestral      | Iniciativa (Esta criatura causa dano de combate antes de criaturas sem a habilidade de iniciativa.)                 | Criatura — Humano Clérigo       | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|      |                                                             |                     |                |                          | Quando Eleito da Ancestral entra em jogo, você ganha 1 ponto de vida para cada card em seu cemitério.               |                                 |                                      |
|    7 | "Общая воля моей рукой вершится".                           | Russian             |         149168 | Избранник Прародителя    | Первый удар (Это существо наносит боевые повреждения раньше существ без Первого удара.)                             | Существо — Человек Священник    | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|      |                                                             |                     |                |                          | Когда Избранник Прародителя входит в игру, вы получаете 1 жизнь за каждую карту на вашем кладбище.                  |                                 |                                      |
|    8 | 「众生所愿，吾手所圆。」                                    | Chinese Simplified  |         147645 | 祖灵的爱民               | 先攻（此生物会比不具先攻异能的生物提前造成战斗伤害。）                                                              | 生物～人类／僧侣                | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|      |                                                             |                     |                |                          | 当祖灵的爱民进场时，你坟墓场中每有一张牌，你便获得1点生命。                                                         |                                 |                                      |
|    9 | Jede ihrer Tränen ist ein Tropfen Unsterblichkeit.          | German              |         148412 | Engel der Gnade          | Fliegend (Diese Kreatur kann außer von fliegenden Kreaturen und Kreaturen mit Reichweite nicht geblockt werden.)    | Kreatur — Engel                 | 57aaebc1-850c-503d-9f6e-bb8d00d8bf7c |
|      |                                                             |                     |                |                          | Wenn der Engel der Gnade ins Spiel kommt, erhältst du 3 Lebenspunkte dazu.                                          |                                 |                                      |
|   10 | Cada lágrima derramada es una gota de inmortalidad.         | Spanish             |         150318 | Ángel de piedad          | Vuela. (Esta criatura no puede ser bloqueada excepto por criaturas que tengan la habilidad de volar o alcance.)     | Criatura — Ángel                | 57aaebc1-850c-503d-9f6e-bb8d00d8bf7c |
|      |                                                             |                     |                |                          | Cuando el Ángel de piedad entre en juego, gana 3 vidas.                                                             |                                 |                                      |


Table: legalities
|   id | format    | status   | uuid                                 |
|-----:|:----------|:---------|:-------------------------------------|
|    1 | commander | Legal    | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|    2 | duel      | Legal    | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|    3 | legacy    | Legal    | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|    4 | modern    | Legal    | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|    5 | penny     | Legal    | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|    6 | premodern | Legal    | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|    7 | vintage   | Legal    | 5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c |
|    8 | commander | Legal    | 57aaebc1-850c-503d-9f6e-bb8d00d8bf7c |
|    9 | duel      | Legal    | 57aaebc1-850c-503d-9f6e-bb8d00d8bf7c |
|   10 | gladiator | Legal    | 57aaebc1-850c-503d-9f6e-bb8d00d8bf7c |


Table: sets
|   id |   baseSetSize | block    | booster                                                                                                                                                                                                                                                         | code   |   isFoilOnly |   isForeignOnly |   isNonFoilOnly |   isOnlineOnly |   isPartialPreview | keyruneCode   | mcmId   | mcmIdExtras   | mcmName         | mtgoCode   | name                                | parentCode   | releaseDate   | tcgplayerGroupId   |   totalSetSize | type      |
|-----:|--------------:|:---------|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-------|-------------:|----------------:|----------------:|---------------:|-------------------:|:--------------|:--------|:--------------|:----------------|:-----------|:------------------------------------|:-------------|:--------------|:-------------------|---------------:|:----------|
|    1 |           383 | Core Set | {'default': {'boosters': [{'contents': {'basic': 1, 'common': 10, 'rare': 1, 'uncommon': 3}, 'weight': 1913922}, {'contents': {'basic': 1, 'common': 9, 'foilCommon': 1, 'rare': 1, 'uncommon': 3}, 'weight': 318987}, {'contents': {'basic': 1, 'common': 10,  | 10E    |            0 |               0 |               0 |              0 |                  0 | 10E           | 74.0    |               | Tenth Edition   | 10E        | Tenth Edition                       |              | 2007-07-13    | 1.0                |            508 | core      |
|    2 |           302 | Core Set | {'default': {'boosters': [{'contents': {'common': 11, 'rare': 1, 'uncommon': 3}, 'weight': 1}], 'boostersTotalWeight': 1, 'sheets': {'common': {'cards': {'0ab4e3e6-f9fe-5fdc-9697-fd20690a0e15': 1, '0b326a61-0389-54e2-ac58-7bb47ca88202': 1, '0f099574-e9f7- | 2ED    |            0 |               0 |               1 |              0 |                  0 | 2ED           |         |               |                 |            | Unlimited Edition                   |              | 1993-12-01    | 115.0              |            302 | core      |
|    3 |           332 |          | {'default': {'boosters': [{'contents': {'common': 8, 'dedicatedFoil2xm': 2, 'rareMythic': 2, 'uncommon': 3}, 'weight': 1}], 'boostersTotalWeight': 1, 'sheets': {'common': {'balanceColors': True, 'cards': {'01df4e32-7fe4-5b8d-9460-0f08fa29153e': 1, '032c60 | 2XM    |            0 |               0 |               0 |              0 |                  0 | 2XM           | 3204.0  | 3209.0        | Double Masters  | 2XM        | Double Masters                      |              | 2020-08-07    | 2655.0             |            384 | masters   |
|    4 |           306 | Core Set | {'default': {'boosters': [{'contents': {'common': 11, 'rare': 1, 'uncommon': 3}, 'weight': 1}], 'boostersTotalWeight': 1, 'sheets': {'common': {'cards': {'06ab1cc7-cc5e-55aa-a1d6-0c174ef0af7d': 1, '08313acd-3e35-59b0-b018-c197d67bb74b': 1, '08c502ff-65f8- | 3ED    |            0 |               0 |               1 |              0 |                  0 | 3ED           |         |               |                 |            | Revised Edition                     |              | 1994-04-01    | 97.0               |            306 | core      |
|    5 |           378 |          |                                                                                                                                                                                                                                                                 | 4BB    |            0 |               1 |               0 |              0 |                  0 | 4ED           |         |               |                 |            | Fourth Edition Foreign Black Border |              | 1995-04-01    |                    |            378 | core      |
|    6 |           378 | Core Set | {'default': {'boosters': [{'contents': {'common': 11, 'rare': 1, 'uncommon': 3}, 'weight': 1}], 'boostersTotalWeight': 1, 'sheets': {'common': {'balanceColors': True, 'cards': {'01cc31a8-e1da-5dde-bec1-b656a32cc866': 1, '05bc686b-4f13-50a8-9357-d973bec32e | 4ED    |            0 |               0 |               1 |              0 |                  0 | 4ED           | 10.0    |               | Fourth Edition  |            | Fourth Edition                      |              | 1995-04-01    | 46.0               |            379 | core      |
|    7 |           165 | Mirrodin | {'default': {'boosters': [{'contents': {'common': 11, 'rare': 1, 'uncommon': 3}, 'weight': 272757}, {'contents': {'common': 10, 'foilCommon': 1, 'rare': 1, 'uncommon': 3}, 'weight': 50853}, {'contents': {'common': 11, 'foilUncommon': 1, 'rare': 1, 'uncomm | 5DN    |            0 |               0 |               0 |              0 |                  0 | 5DN           | 47.0    |               | Fifth Dawn      | 5DN        | Fifth Dawn                          |              | 2004-06-04    | 43.0               |            165 | expansion |
|    8 |           455 | Core Set | {'default': {'boosters': [{'contents': {'common': 11, 'rare': 1, 'uncommon': 3}, 'weight': 1}], 'boostersTotalWeight': 1, 'sheets': {'common': {'balanceColors': True, 'cards': {'078c45d3-46da-52e2-822f-30681e5daa20': 1, '0b3dc354-ebae-5fad-bad7-d5b4f154ae | 5ED    |            0 |               0 |               1 |              0 |                  0 | 5ED           | 23.0    |               | Fifth Edition   |            | Fifth Edition                       |              | 1997-03-24    | 44.0               |            460 | core      |
|    9 |           351 | Core Set | {'default': {'boosters': [{'contents': {'common': 11, 'rare': 1, 'uncommon': 3}, 'weight': 1}], 'boostersTotalWeight': 1, 'sheets': {'common': {'balanceColors': True, 'cards': {'0060dad6-8a5b-55b3-a02d-4b725db44fc3': 1, '0199da87-80b6-5816-954c-e58f75835e | 6ED    |            0 |               0 |               1 |              0 |                  0 | 6ED           |         |               |                 |            | Classic Sixth Edition               |              | 1999-04-21    | 23.0               |            351 | core      |
|   10 |           354 | Core Set | {'default': {'boosters': [{'contents': {'basic': 1, 'common': 10, 'rare': 1, 'uncommon': 3}, 'weight': 8556273}, {'contents': {'basic': 1, 'common': 9, 'foilCommon': 1, 'rare': 1, 'uncommon': 3}, 'weight': 950697}, {'contents': {'basic': 1, 'common': 10,  | 7ED    |            0 |               0 |               0 |              0 |                  0 | 7ED           | 37.0    |               | Seventh Edition | 7E         | Seventh Edition                     |              | 2001-04-11    | 2.0                |            354 | core      |


Table: set_translations
|   id | language            | setCode   | translation                       |
|-----:|:--------------------|:----------|:----------------------------------|
|    1 | Chinese Simplified  | 10E       | 核心系列第十版                    |
|    2 | Chinese Traditional | 10E       | 核心系列第十版                    |
|    3 | French              | 10E       | Dixième édition                   |
|    4 | German              | 10E       | Hauptset Zehnte Edition           |
|    5 | Italian             | 10E       | Set Base Decima Edizione          |
|    6 | Japanese            | 10E       | 第10版基本セット                  |
|    7 | Korean              | 10E       | 코어세트 10판                     |
|    8 | Portuguese (Brazil) | 10E       | Coleção Básica Décima Edição      |
|    9 | Russian             | 10E       | Базовый выпуск Десятое Издание    |
|   10 | Spanish             | 10E       | Colección Básica - Décima Edición |


Table: rulings
|   id | date       | text                                                                                                                                                                                                                                                            | uuid                                 |
|-----:|:-----------|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-------------------------------------|
|    1 | 2007-07-15 | You draw the card when Bandage resolves, not when the damage is actually prevented.                                                                                                                                                                             | 6d268c95-c176-5766-9a46-c14f739aba1c |
|    2 | 2007-02-01 | If you double a negative life total, you do the real math. A life total of -10 becomes -20.                                                                                                                                                                     | 56f4935b-f6c5-59b9-88bf-9bcce20247ce |
|    3 | 2007-07-15 | Beacon of Immortality’s effect counts as life gain (or life loss, if the life total was negative) for effects that trigger on or replace life gain (or life loss).                                                                                              | 56f4935b-f6c5-59b9-88bf-9bcce20247ce |
|    4 | 2007-07-15 | If a Beacon is countered or doesn’t resolve, it’s put into its owner’s graveyard, not shuffled into the library.                                                                                                                                                | 56f4935b-f6c5-59b9-88bf-9bcce20247ce |
|    5 | 2010-08-15 | The affected creature’s last known existence on the battlefield is checked to determine its toughness.                                                                                                                                                          | 7fef665c-36a1-5f7a-9299-cf8938708710 |
|    6 | 2008-08-01 | The ability triggers even if the Specter’s damage is being redirected to an opponent. It does not trigger if damage that would have been dealt to the opponent is redirected to a nonopponent player or a creature, or if the damage is prevented.              | f39b4446-0ca6-5446-8507-4b1ba37bb3e7 |
|    7 | 2005-06-01 | You choose how the damage will be divided among the target creatures at the time you cast Hail of Arrows. Each target must be dealt at least 1 damage. If any of those creatures becomes an illegal target before Hail of Arrows resolves, the division of dama | c19bcfc2-fc10-5040-8239-1c193098df47 |
|    8 | 2007-07-15 | High Ground’s effect is cumulative. If you have a creature that can already block an additional creature, now it can block three creatures.                                                                                                                     | 60f49caf-3583-5f85-b4b3-08dca73a8628 |
|    9 | 2007-07-15 | High Ground allows you to make some complicated blocks. For example, if you’re being attacked by three creatures (call them A, B, and C) and you control three creatures (X, Y, and Z), you can have X block A and B, Y block B and C, and Z block just C, amon | 60f49caf-3583-5f85-b4b3-08dca73a8628 |
|   10 | 2009-10-01 | A “blocking creature” is one that has been declared as a blocker this combat, or one that was put onto the battlefield blocking this combat. Unless that creature leaves combat, it continues to be a blocking creature through the end of combat step, even if | 9a14261a-b567-5429-a5ca-a913e15d8bf7 |


Question: For all the set of cards that has Japanese translation, what is the percentage of them are only available in non-foil?

db_id: card_games
tables: name: cards
data: cards.csv
name: foreign_data
data: foreign_data.csv
name: legalities
data: legalities.csv
name: sets
data: sets.csv
name: set_translations
data: set_translations.csv
name: rulings
data: rulings.csv
label: SELECT CAST(SUM(CASE WHEN isNonFoilOnly = 1 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(id) FROM sets WHERE code IN ( SELECT setCode FROM set_translations WHERE language = 'Japanese' )
sqlite_path: $MMTU_HOME/data_sqlite/bird/dev_20240627/dev_databases/card_games/card_games.sqlite