What does this query count?SELECT COUNT(*)FROM Sales.Invoices RIGHT JOIN Sales.OrdersON Sales.Invoices.OrderID = Sales.Orders.OrderID;Group of answer choicesRows in Sales.Invoices, whether or not they have a matching row in Sales.Orders based on OrderIDRows in Sales.Invoices that have a matching row in Sales.Orders based on the OrderIDRows in Sales.Orders, whether or not they have a matching row in Sales.Invoices based on OrderIDRows from Sales.Invoices and from Sales.Orders, whether or not they have a matching OrderID

The output of the COUNT() function is the number of rows or column values that would be selected by the query.Question 4Select one:TrueFalse

Select the correct answerConsider the following SQL query: SELECT customer_id, MAX(total_amount) AS max_amount FROM Orders GROUP BY customer_id HAVING COUNT(*) > 1;What will be the output of this query?OptionsThe customer IDs and the maximum order amount for customers who have placed more than one order.An error because the HAVING clause is used without an aggregate function in the SELECT clause. An error because the GROUP BY clause is not properly used.The customer IDs and the average order amount for customers who have placed more than one order.

29. What is the result of the following SQL Query? SELECT COUNT(*), AVG(amount) FROM Orders WHERE amount > 200; Number of orders with amount > 200 and the average amount of these orders.Total number of orders and the average amount of all orders.Number of customers with orders > 200 and the average order amount per customer.Total number of orders > 200 and the average number of orders.

Which SQL function is used to count the number of rows in a SQL query?COUNT()NUMBER()SUM()COUNT(*)

tblProducts Table ProductID   SupplierID   CategoryID   ProductName 1 1 1 Chai2 1 1 Chang3 1 2 Aniseed Syrup4 2 2 Chef Anto's Cajun Using the tblProducts Table shown above, which of the following SQL statements returns the total number of products that come from SupplierID=1 in the tblProducts table?Question 8Select one:a.Select * From tblProducts Count(*);b.Select  Count(*) from tblProducts;c.Select  Count(*) from tblProducts Where SupplierID=1;d.Count(*) tblProducts;