You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.
109
109
```sql
110
110
-- mysql
111
-
111
+
SELECT DISTINCT city
112
+
FROM station
113
+
WHERE city REGEXP'[aeiouAEIOU]$';
112
114
```
113
115
114
-
###
115
-
116
+
###Weather Observation Station 8
117
+
Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates.
116
118
```sql
117
119
-- mysql
118
-
120
+
SELECT DISTINCT city
121
+
FROM station
122
+
WHERE city REGEXP'^[aeiouAEIOU].*[aeiouAEIOU]$';
119
123
```
120
124
121
-
###
122
-
125
+
###Weather Observation Station 9
126
+
Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates.
123
127
```sql
124
128
-- mysql
125
-
129
+
SELECT DISTINCT city
130
+
FROM station
131
+
WHERE NOT city REGEXP'^[aeiouAEIOU]';
126
132
```
127
133
128
-
###
129
-
134
+
###Weather Observation Station 10
135
+
Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates.
130
136
```sql
131
137
-- mysql
132
-
138
+
SELECT DISTINCT city
139
+
FROM station
140
+
WHERE NOT city REGEXP'[aeiouAEIOU]$';
133
141
```
134
142
135
-
###
136
-
143
+
###Weather Observation Station 11
144
+
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
137
145
```sql
138
146
-- mysql
139
-
147
+
SELECT DISTINCT city
148
+
FROM station
149
+
WHERE NOT city REGEXP'^[aeiouAEIOU].*[aeiouAEIOU]$';
140
150
```
141
151
142
-
###
143
-
152
+
###Weather Observation Station 12
153
+
Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.
144
154
```sql
145
155
-- mysql
146
-
156
+
SELECT DISTINCT city
157
+
FROM station
158
+
WHERE NOT (city REGEXP'^[aeiouAEIOU]'OR city REGEXP'[aeiouAEIOU]$');