CREATE TABLE rating (rid NUMBER, mid NUMBER, stars NUMBER, ratingdate TIME)
CREATE TABLE reviewer (rid NUMBER, name CLOB)
CREATE TABLE movie (mid NUMBER, title CLOB, year NUMBER, director CLOB)

What is the total number of ratings that has more than 3 stars?
SELECT COUNT(*) FROM rating WHERE stars > 3
SELECT COUNT(*) FROM "rating" WHERE "stars" > 3