Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual é o ranking para a Murphy Oil?
 ###Tabelas: CREATE TABLE former_professional_football_teams (former_professional_football_teams_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Sport VARCHAR, Played VARCHAR, Venue VARCHAR, Championships VARCHAR) CREATE TABLE public_companies (public_companies_id AUTO_INCREMENT PRIMARY KEY, State Rank by Revenue INT, Company Name VARCHAR, National Rank INT, Revenue ($billions) 2012 estimate VARCHAR, Headquarters City VARCHAR, Known for VARCHAR) CREATE TABLE 2009_2010_table (2009_2010_table_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Played VARCHAR, Drawn VARCHAR, Lost VARCHAR, Points for VARCHAR, Points against VARCHAR, Tries for VARCHAR, Tries against VARCHAR, Try bonus VARCHAR, Losing bonus VARCHAR, Points VARCHAR) CREATE TABLE parliamentary_elections (parliamentary_elections_id AUTO_INCREMENT PRIMARY KEY, Election date INT, Party leader VARCHAR, Number of votes received INT, Percentage of votes VARCHAR, Number of deputies INT) CREATE TABLE winners_of_the_danish_grand_prix (winners_of_the_danish_grand_prix_id AUTO_INCREMENT PRIMARY KEY, Year INT, Driver VARCHAR, Constructor VARCHAR, Location VARCHAR, Formula VARCHAR, Report VARCHAR)  
SELECT State Rank by Revenue FROM public_companies WHERE Company Name = Murphy Oil