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

Question 1You have a table that lists products. Because there are different editions, there are duplicate product names in the productName field. You need to create a list of all of the different product names. If there are different editions of the product, you only want to list one record for each product name. What query should you execute? 1 pointSELECT DISTINCT productName FROM productsSELECT UNIQUE productName FROM productsSELECT INDIVIDUAL productName FROM productsSELECT SEPARATE productName FROM products

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.

Consider the following table structure:Productidnamepricetype_idProduct_typeidnamediscountWhich of the following query is used to display the product_type name, product name and discount of product_type named 'Books'?

Single File Programming QuestionProblem StatementGiven Product table, implement a Cursor inside Stored Procedure to count how many products(product_name) of each product type exists with product type passed as a input argument to the procedure.As Cursor can be implemented inside Stored Procedure, Create a procedure.Procedure Name: ProductCount(IN product_name VARCHAR (30))Product type should be passed as an argument.Table Name: Productproduct_id intproduct_type varchar (30)product_name varchar (30)Note:Table names are case sensitive.Use proper delimiter to define procedure. At the end of procedure, reset the delimiter to ;Input format :The input records are already prepopulated, as given in the problem statement.Output format :The procedure should display the count of products based on a given product type as shown below.ProductCount7Refer to the sample output for the column headers.Note :The program will be evaluated only after the “Submit Code” is clicked.Extra spaces and new line characters in the program output will result in the failure of the test case.