SHOW:
|
|
- or go back to the newest paste.
| 1 | - | """ |
| 1 | + | SELECT 'GLE' AS "Indicator", |
| 2 | - | |
| 2 | + | (SELECT lifeexpectancy FROM country WHERE governmentform = 'Federal Republic' ORDER BY lifeexpectancy DESC LIMIT 1) AS "Federal republic", |
| 3 | - | Это индивидуальное задание на стажировку ВКонтакте. Требуется протестировать |
| 3 | + | (SELECT lifeexpectancy FROM country WHERE governmentform = 'Republic' ORDER BY lifeexpectancy DESC LIMIT 1) AS "Republic", |
| 4 | - | три метода str и три метода set, как минимум один из тестов для каждой |
| 4 | + | (SELECT lifeexpectancy FROM country WHERE lifeexpectancy IS NOT NULL AND governmentform != 'Republic' AND governmentform != 'Federal Republic' ORDER BY lifeexpectancy DESC LIMIT 1) AS "Other" |
| 5 | - | структуры должен быть параметризирован |
| 5 | + | UNION SELECT 'LLE' AS "Indicator", |
| 6 | - | |
| 6 | + | (SELECT lifeexpectancy FROM country WHERE governmentform = 'Federal Republic' ORDER BY lifeexpectancy LIMIT 1), |
| 7 | - | """ |
| 7 | + | (SELECT lifeexpectancy FROM country WHERE governmentform = 'Republic' ORDER BY lifeexpectancy LIMIT 1), |
| 8 | - | |
| 8 | + | (SELECT lifeexpectancy FROM country WHERE lifeexpectancy IS NOT NULL AND governmentform != 'Republic' AND governmentform != 'Federal Republic' ORDER BY lifeexpectancy LIMIT 1) |
| 9 | - | import pytest |
| 9 | + | ORDER BY "Indicator" |
| 10 | - | |
| 10 | + | LIMIT 2; |
