You are writing a query that will give you the total cost to the Pet Rescue organization of rescuing animals. The cost of each rescue is stored in the Cost column. You want the result column to be called “Total_Cost”. Which of the following SQL queries is correct?1 pointSELECT SUM(Cost) FROM PetRescueSELECT SUM(Cost) AS Total_Cost FROM PetRescueSELECT SUM(Total_Cost) From PetRescueSELECT Total_Cost FROM PetRescue

Consider a database with two tables, "Customers" and "Orders", where the "Customers" table has the following columns: "CustomerID", "FirstName", "LastName", and the "Orders" table has the following columns:"OrderID", "CustomerID", "OrderDate", "TotalCost". Which of the following SQL queries will return the first name, last name, and total cost of all orders placed by customers with the last name "Smith"?Answer( Please choose a correct answer )   CLEAR SELECT FirstName, LastName, TotalCost FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE LastName = 'Smith'; SELECT FirstName, LastName, TotalCost FROM Orders JOIN Customers ON Orders.CustomerID = Customers.CustomerID WHERE LastName = 'Smith'; SELECT FirstName, LastName, TotalCost FROM Customers, Orders WHERE Customers.CustomerID = Orders.CustomerID AND LastName = 'Smith'; SELECT FirstName, LastName, TotalCost FROM Orders, Customers WHERE Orders.CustomerID = Customers.CustomerID AND LastName = 'Smith';

When writing a query to find the total spent per category, which columns would you typically include in the SELECT clause?category onlyamount onlycategory, SUM(amount)* (select all columns)

The _________ function takes all of the values in each of the specified cells and totals their values?Select one:A.SumB.AvgC.Total

Write a query to find the total amount you spent in each category (Groceries, Entertainment, etc.).

Total Spent per Category: Write a query to find the total amount you spent in each category (Groceries, Entertainment, etc.). Hint: Use GROUP BY category and SUM(amount).