❓ Question
❗ Answer
SELECT DISTINCT city FROM station WHERE id % 2 = 0
📌 Discussion
❓ Question
❗ Answer
SELECT count(city) - count(DISTINCT city) FROM station
📌 Discussion
❓ Question
❗ Answer
SELECT city, length(city)
FROM station
ORDER BY length(city), city
LIMIT 1;
SELECT city, length(city)
FROM station
ORDER BY length(city) DESC, city DESC
LIMIT 1;
📌 Discussion
❓ Question
❗ Answer
SELECT DISTINCT city
FROM station
WHERE LEFT(city,1) in ('a','e','i','o','u')
📌 Discussion
❓ Question
❗ Answer
SELECT DISTINCT city
FROM station
WHERE RIGHT(city,1) in ('a','e','i','o','u')
📌 Discussion
❓ Question
❗ Answer
SELECT DISTINCT city
FROM station
WHERE LEFT(city,1) in ('a','e','i','o','u') AND RIGHT(city,1) in ('a','e','i','o','u')
📌 Discussion