After a discussion of which users were from Australia, I wrote my first SQL query to find out:
SELECT u.DisplayName'Display Name', u.Reputation'Rep', u.Location'Location'
FROM Users u
WHERE u.Location LIKE '%Australia%'
ORDER BY 'Rep' DESC
As always, please tell me the good, the bad, and the ugly.
[The query can be found here][1] [1]:http://data.stackexchange.com/codereview/query/301624/australian-usersThe query can be found here
After a discussion of which users were from Australia, I wrote my first SQL query to find out:
SELECT u.DisplayName'Display Name', u.Reputation'Rep', u.Location'Location'
FROM Users u
WHERE u.Location LIKE '%Australia%'
ORDER BY 'Rep' DESC
As always, please tell me the good, the bad, and the ugly.
[The query can be found here][1] [1]:http://data.stackexchange.com/codereview/query/301624/australian-users
After a discussion of which users were from Australia, I wrote my first SQL query to find out:
SELECT u.DisplayName'Display Name', u.Reputation'Rep', u.Location'Location'
FROM Users u
WHERE u.Location LIKE '%Australia%'
ORDER BY 'Rep' DESC
As always, please tell me the good, the bad, and the ugly.
Query to annoy Kiwisfind users from Australia
- 12k
- 5
- 41
- 93