SELECT lot_no "Lot Number", COUNT(*) "Number of Cars Available"FROM carsWHERE model = 'Fire'GROUP BY lot_noHAVING COUNT(*) > 10ORDER BY COUNT(*);In the above statement which clause restricts which groups are displayed?Select one:a.SELECT lot_no "Lot Number", COUNT(*) "Number of Cars Available"b.GROUP BY lot_noc.HAVING COUNT(*) > 10d.WHERE model = 'Fire'e.ORDER BY COUNT(*)

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.

Modify the query with the following specifications:a. ‘Title’: Grouped by.b. ‘SeatNumber’: Count.c. Only display data from the ‘Movie’ and ‘CountOfSeatNumber’ fields. If you run thequery, it should look like this

In SQL, which clause is used to specify a condition for grouping rows?Options HAVINGGROUP BYORDER BYWHERE

What is the order of statements in the select statement ?OptionsSELECT FROM WHERE GROUP BY HAVING ORDER BYSELECT WHERE FROM GROUP BY HAVING ORDER BYNone of theseSELECT FROM GROUP BY WHERE HAVING ORDER BYSELECT FROM WHERE GROUP BY ORDER BY HAVING

Which of the below choices will display all the data that fits certain criteria countifaverageifsumifadvanced filter