Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
16.0k views
in Information Technology by (71.2k points)

Observe the given table named “Loan” carefully and predict the output of the following queries:

Loan

(i) select count(file_no)-count(loan_amt) from loan;

(ii) select Cust_Name, Loan_Amt from loan where month(cheque_dt)=7;

(iii) SELECT concat(left(file_no,2),right(cust_name,2)) AS “ID” from loan where Bank='ICUCI Ltd.';

(iv) select round(loan_amt-loan_amt*10/100) As "Discounted Payment" from loan where loan_amt>700000;

1 Answer

+1 vote
by (76.3k points)
selected by
 
Best answer

(i)

(ii) 

(iii)

(iv)

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...