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);

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')

Consider the below tables:Customer TableColumn NameDatatypeConstraintcustNoNumberPKcustnameVarchar custaddressvarchar Cust_credit_limitNumber  Grade  TableColumn NameDatatypeConstraintGradeVarchar StartvalNumber EndvalNumber To display names and grades of customers who have the highest credit limit.Which SQL statements would accomplish the task? Select one or more:a.SELECT custname, gradeFROM customers, gradesWHERE (SELECT MAX(cust_credit_limit)FROM customers) BETWEEN startval and endvalAND cust_credit_limit BETWEEN startval AND endval;b.SELECT custname, gradeFROM customers, gradesWHERE cust_credit_limit = (SELECT MAX(cust_credit_limit)FROM customers)AND cust_credit_limit BETWEEN startval AND endval;c.SELECT custname, gradeFROM customers, gradesWHERE cust_credit_limit IN (SELECT MAX(cust_credit_limit)FROM customers)AND MAX(cust_credit_limit) BETWEEN startval AND endval;d.SELECT custname, gradeFROM customers, gradesWHERE (SELECT MAX(cust_credit_limit)FROM customers) BETWEEN startval and endval;

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

List all orders, showing order number, customer name and credit limit of a customer.Orders Table:Order_Number, Customer_Number, Product_AmountCustomers Table:Customer_Number, Customer_Name, Credit_LimitWhich of the below query satisfy the above question:A. Select Order_Number, Customer_Name, Credit_Limitfrom Customers left join Orderswhere Customer_Number = Customer_NumberB. Select Order_Number, Customer_Name, Credit_Limitfrom Customers INNER JOIN OrdersON Customers.Customer_Number = Orders.Customer_Number;

Which of the following queries will retrieve the HIGHEST value of SALARY in a table called EMPLOYEES?1 pointSELECT MOST(SALARY) FROM EMPLOYEESSELECT MIN(SALARY) FROM EMPLOYERSELECT MAX(SALARY) FROM EMPLOYEESSELECT SALARY FROM EMPLOYEES WHERE MAX