text: CREATE TABLE review (u_id VARCHAR); CREATE TABLE useracct (u_id VARCHAR) -- Find the number of users who did not write any review. SELECT COUNT(*) FROM useracct WHERE NOT u_id IN (SELECT u_id FROM review) CREATE TABLE player (Id VARCHAR) -- How many players are there? SELECT COUNT(*) FROM player CREATE TABLE player (Player_name VARCHAR, Votes VARCHAR) -- List the names of players in ascending order of votes. SELECT Player_name FROM player ORDER BY Votes CREATE TABLE player (Gender VARCHAR, Occupation VARCHAR) -- What are the gender and occupation of players? SELECT Gender, Occupation FROM player CREATE TABLE player (Player_name VARCHAR, residence VARCHAR, Occupation VARCHAR) -- List the name and residence for players whose occupation is not "Researcher". SELECT Player_name, residence FROM player WHERE Occupation <> "Researcher" CREATE TABLE player (Sponsor_name VARCHAR, Residence VARCHAR) -- Show the names of sponsors of players whose residence is either "Brandon" or "Birtle". SELECT Sponsor_name FROM player WHERE Residence = "Brandon" OR Residence = "Birtle" CREATE TABLE player (Player_name VARCHAR, Votes VARCHAR) -- What is the name of the player with the largest number of votes? SELECT Player_name FROM player ORDER BY Votes DESC LIMIT 1 CREATE TABLE player (Occupation VARCHAR) -- Show different occupations along with the number of players in each occupation. SELECT Occupation, COUNT(*) FROM player GROUP BY Occupation