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;

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

Consider the below table:Products TableColumn NameDatatypeConstraintProd_idNumberPKProd_nameVarchar Prod_list_pricevarchar Cust_credit_limitNumber  What would be the outcome of executing the below SQL statement?select prod_name from products where prod_id in(select prod_id from products where prod_list_price=(select max(prod_list_price) from products where prod_list_price<(select max(prod_list_price)from products)));Select one:a.It shows the names of all products in the table.b.It shown the names of products whose list price is the second highest in the tablec.It produces an errord.It shown the names of all products whose list price is less than the maximum list priceClear my choiceQuestion 9Not yet answeredMarked out of 1.00Flag questionTipsQuestion text_____ is used to retrieve records that do not meet the join conditionSelect one:a.Outer Joinb.Equi Joinc.Non Equi Joind.Self Join

Consider following schema and write SQL for given statements.Student (RollNo, Name, DeptCode, City)Department (DeptCode, DeptName)Result (RollNo, Semester, SPI)1. List out the RollNo, Name along with SPI of Student.2. Display student name who got highest SPI in semester 1.3. Display the list of students whose DeptCode is 5, 6,7,10

For the following tables and a query:Student (studentId, studentName, address) Result (studentId, subjectId, score) Subject (subjectId, subjectName) Which code snippet will display students with the highest 'SQL Basics' test scores?SELECT TOP 1 WITH TIES s.*FROM STUDENT s JOIN RESULT r ON s.studentId = r.studentIdWHERE r.subjectId =(SELECT ss.subjectId FROM dbo.Subject ssWHERE ss.subjectName = 'SQL Basics');SELECT TOP 1 WITH TIES s.*FROM STUDENT s JOIN RESULT r ON s.studentId = r.studentIdWHERE r.subjectName = 'SQL Basics'ORDER BY score DESC;SELECT TOP 1 WITH TIES s.*FROM STUDENT s JOIN RESULT r ON s.studentId = r.studentIdWHERE r.subjectId = 'SQL Basics'ORDER BY score DESC;SELECT TOP 1 WITH TIES s.*FROM STUDENT s JOIN RESULT r ON s.studentId = r.studentIdWHERE r.subjectId =(SELECT ss.subjectId FROM dbo.Subject ssWHERE ss.subjectName = 'SQL Basics')ORDER BY score DESC;

Students(StudentID, Name, Grade)A Students table is shown above. Which of the following partial SQL query phrases to retrieve data for Students with a grade greater than 60?Question 9Select one:a.Where Grade<60b.Where Grade=60c.Having Grade>60 d.Where Grade>60