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';

Consider the table Employee given below: EmpId EmpName Salary DeptId200 Alex 30000 100201 Tom 20000 101202 Dick 40000 100202 Harry 15000 102205 Mary 50000 101206 Karl 40000 101SELECT EmpName FROM Employee WHERE Salary > ALL (SELECT Salary FROM Employee WHERE DeptId = 100);What will be the outcome of the query given above?

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

You are creating a query that will join the results of two tables. You begin typing the query:SELECT customers.firstName, customers.lastName, orders.orderDateFROM customers ______ JOIN ordersON customers.customerNumber = orders.customerNumberYou want the query to combine each row in the customers table with each row in the orders table such that the output will be equal to the number of rows in the customers table multiplied by the number of rows in the orders table.What should you type in the blank space? (Please type your answer all in upper case. Example: SELECT or UNION ALL)

Which of the following methods are available for costing inventory? (Select all that apply.)Multiple select question.Simple-averageWeighted-averageNIFOSpecific identificationLIFOFIFO

Part A - Single and multiple table queries Value: 10% For the first five questions you have to provide your answer in the form of a SQL statement, with description before as necessary. For example: 1. Example Question: Select all columns from the `Customer` table Example Answer: -- This answer will select out all the columns from the Customer table SELECT * from Customer; Questions 1 – 5: 1. List in ascending order the Last Names of all borrowers with Card Number less than 150. 2. What are the records of those loans between 3 June 2014 and 8 Mar 2018? ◦ The output should include the name of the cardholder, and title of the book ◦ List in ascending order by last name and first name 3. Find the total numbers of loans with last name beginning with D through E (including E); include last name beginning with Q as well as Z also. ◦ The output of the above question should be a column containing the sum of all the loan based on the condition in the query, alternatively the output could be a table with columns that has the last name as per the condition in the query condition, also the table contains the list of loans. 4. Find all borrowers for a loan that have the Date-in before 15-March-15 and the Card number between 100 and 300 in Karama or Darwin. ◦ The output for the above question is a list of all borrowers (first name and last name) based on the condition in the query. 5. Find the number of loans, which have been made from each branch? ◦ Note all branches need to be included even those with no loans ◦ The output of the above question is a table containing the list of loans only as per the condition in the query