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 é a receita total para cada restaurante, incluindo a porcentagem de origem sustentável, para o mês de janeiro de 2021?
 ###Tabelas: 
CREATE TABLE Restaurants (RestaurantID int, RestaurantName varchar(50), City varchar(50)); INSERT INTO Restaurants (RestaurantID, RestaurantName, City) VALUES (1, 'The Green Garden', 'New York'); INSERT INTO Restaurants (RestaurantID, RestaurantName, City) VALUES (2, 'Healthy Bites', 'Los Angeles'); CREATE TABLE Revenue (RevenueID int, RestaurantID int, RevenueDate date, RevenueAmount numeric(10, 2)); INSERT INTO Revenue (RevenueID, RestaurantID, RevenueDate, RevenueAmount) VALUES (1, 1, '2021-01-01', 5000); INSERT INTO Revenue (RevenueID, RestaurantID, RevenueDate, RevenueAmount) VALUES (2, 1, '2021-01-02', 6000); INSERT INTO Revenue (RevenueID, RestaurantID, RevenueDate, RevenueAmount) VALUES (3, 2, '2021-01-01', 4000); INSERT INTO Revenue (RevenueID, RestaurantID, RevenueDate, RevenueAmount) VALUES (4, 2, '2021-01-02', 3000); CREATE TABLE Sustainability (SustainabilityID int, RestaurantID int, SustainabilityPercentage numeric(5, 2)); INSERT INTO Sustainability (SustainabilityID, RestaurantID, SustainabilityPercentage) VALUES (1, 1, 0.75); INSERT INTO Sustainability (SustainabilityID, RestaurantID, SustainabilityPercentage) VALUES (2, 2, 0.85);
SELECT R.RestaurantName, S.SustainabilityPercentage, SUM(R.RevenueAmount) AS TotalRevenue FROM Restaurants R INNER JOIN Revenue RV ON R.RestaurantID = RV.RestaurantID INNER JOIN Sustainability S ON R.RestaurantID = S.RestaurantID WHERE RV.RevenueDate BETWEEN '2021-01-01' AND '2021-01-31' GROUP BY R.RestaurantName, S.SustainabilityPercentage;