CREATE TABLE tweets (id BIGINT, uid INT, text CHAR, createdate DATETIME)
CREATE TABLE user_profiles (uid INT, name VARCHAR, email VARCHAR, partitionid INT, followers INT)
CREATE TABLE follows (f1 INT, f2 INT)

List the name and number of followers for each user, and sort the results by the number of followers in descending order.
SELECT name, followers FROM user_profiles ORDER BY followers DESC
SELECT "name", "followers" FROM "user_profiles" ORDER BY "followers" DESC NULLS LAST