CREATE TABLE restaurant_type (restypeid DECIMAL, restypename TEXT, restypedescription TEXT)
CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)
CREATE TABLE visits_restaurant (stuid DECIMAL, resid DECIMAL, time TIME, spent DECIMAL)
CREATE TABLE restaurant (resid DECIMAL, resname TEXT, address TEXT, rating DECIMAL)
CREATE TABLE type_of_restaurant (resid DECIMAL, restypeid DECIMAL)

Which restaurants have highest rating? List the restaurant name and its rating.
SELECT resname, rating FROM restaurant ORDER BY rating DESC LIMIT 1
SELECT "resname", "rating" FROM "restaurant" ORDER BY "rating" DESC NULLS LAST LIMIT 1