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;

The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold and have been ordered more than 10 times: SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*)>10 GROUP BY prod_id HAVING COUNT(*)>10; Which statement is true regarding this SQL statement? Select one:a.It produces an error because COUNT (*) should be specified the SELECT clause also.b.It executes successfully and generates the required result.c.It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*) .d.It produces an error because COUNT (*) should be only in the HAVING clause and not in the WHERE clause.

we have following relations:Supplier(S#,sname,status,city)Parts(P#,pname,color,weight,city)SP(S#,P#,quantity)Answer the following queries.(1) Find s# of supplier who supplies ‘red’ part.(2) Count number of supplier who supplies ‘red’ part.(3) Sort the supplier table by sname?

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

1. What is the SQL to do this result?

ou need to run a query that will count all of the records in the products table. The products table lists the productID, productName, and productDescription. The productID field is the primary key. There are no other constraints on any of the fields. What query or queries should you execute? (Choose all that apply.)1 pointSELECT count() * FROM productsSELECT count(DISTINCT productName) FROM productsSELECT count(productID) FROM productsSELECT count(*) FROM productsCoursera Honor Code  Learn more