SELECT cust_city, COUNT(cust_last_name) FROM customersWHERE cust_credit_limit > 1000 GROUP BY cust_city HAVING AVG(cust_credit_limit) BETWEEN 5000 AND 6000;Which statement is true regarding the outcome of the above query? Select one:a.It executes successfully.b.It returns an error because WHERE and HAVING clauses cannot be used in the same SELECT statement.c.It returns an error because the BETWEEN operator cannot be used in the HAVING clause.d.It returns an error because WHERE and HAVING clauses cannot be used to apply conditions on the same column. e.Date functions

Using the CUSTOMERS table, you need to generate a report that shown the average credit limit for customers in WASHINGTON and NEW YORK. Which SQL statement would produce the required result?Select one:a.SELECT cust_city,AVG(cust_credit_limit) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_city,cust_credit_limit;b.SELECT cust_city,AVG(cust_credit_limit) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_city;c.SELECT cust_city,AVG(cust_credit_limit) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_credit_limit,cust_city;d.SELECT cust_city,AVG(NVL(cust_credit_limit,0)) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK')

Select the correct answerWhat will be the result of the following query? SELECT customer_id, AVG(total_amount) AS avg_amount FROM Orders GROUP BY customer_id HAVING AVG(total_amount) > 200;OptionsReturns the customer IDs and average order amounts for all customers.Returns the customer IDs and total order amounts for customers with an average order amount greater than 200.Returns an error because the HAVING clause is not allowed in this context.Returns the customer IDs and average order amounts for customers with an average order amount greater than 200.

Which statement would display the highest credit limit available in each income level in each city in the Customers table? Select one:a.SELECT cust_city, cust_income_level,MAX(cust_credit_limit)FROM customersGROUP BY cust_city, cust_income_level;b.SELECT cust_city, cust_income_level,MAX(cust_credit_limit)FROM customersGROUP BY cust_city, cust_income_level,cust_credit_limit;c.SELECT cust_city, cust_income_level,MAX(cust_credit_limit)FROM customersGROUP BY cust_credit_limit , cust_income_level, cust_city ;d.SELECT cust_city, cust_income_level,MAX(cust_credit_limit)FROM customersGROUP BY cust_city , , cust_income_level ,MAX(cust_credit_limit);

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.

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.