Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
# 7) Using regex to select city starts with all letters and ends with vowels SELECT COUNT(city) - COUNT(DISTINCT city) FROM citytable WHERE city RLIKE '^[nz].*[^aiueo]$' AND lat > 121.5 AND lon < 25.3; # 8) Update lat to p*lat, lon to q*lon using parity checking UPDATE citytable SET lat = lat*2, lon = lon*5 WHERE CASE WHEN 'od' = 'ev' THEN (id % 2) = 0 ELSE id % 2 = 1 END; # 9) Find sum of lat, lon, and difference between biggest and smallest city SELECT ROUND(SUM(lat), 3), ROUND(SUM(lon), 3), MAX(LENGTH(city)) - MIN(LENGTH(city)) FROM (SELECT*FROM citytable WHERE CASE WHEN 'even' = 'even' THEN (id % 2) = 0 ELSE id % 2 = 1 END ORDER BY LENGTH(city) DESC, city DESC LIMIT 5) AS newTable;
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
