Scribd
Upload
9 views2 pages

Assignment SQL

The document contains a series of SQL queries related to banking operations, including selecting customer names, branch details, and deposit amounts based on various conditions. It also includes updates to deposit amounts, deletions from the borrow table, and joins between different tables to extract related data. Overall, the queries focus on retrieving and manipulating data pertaining to customers, deposits, and loans across different cities.

Uploaded by

The Seeker 18
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views2 pages

Assignment SQL

The document contains a series of SQL queries related to banking operations, including selecting customer names, branch details, and deposit amounts based on various conditions. It also includes updates to deposit amounts, deletions from the borrow table, and joins between different tables to extract related data. Overall, the queries focus on retrieving and manipulating data pertaining to customers, deposits, and loans across different cities.

Uploaded by

The Seeker 18
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

SELECT * FROM DEPOSIT;

SELECT CNAME FROM CUSTOMER WHERE CITY = "NAGPUR";


SELECT * FROM BRANCH WHERE CITY = "BOMBAY";
SELECT CNAME FROM DEPOSIT WHERE AMOUNT > 4000;
SELECT ADATE FROM DEPOSIT WHERE CNAME = "ANIL";
SELECT CNAME FROM BORROW WHERE LOANNO = 321;
SELECT CNAME,BNAME FROM DEPOSIT;
SELECT CNAME FROM DEPOSIT WHERE ADATE > "1995-12-01";
SELECT BNAME FROM BRANCH WHERE CITY = "DELHI";
SELECT SUM(AMOUNT) AS TOTAL_LOAN FROM BORROW;
SELECT DISTINCT [Link] FROM DEPOSIT D LEFT JOIN BORROW B ON [Link]
= [Link] WHERE [Link] IS NULL;
UPDATE DEPOSIT SET AMOUNT = AMOUNT * 1.10;
DELETE FROM BORROW WHERE BNAME = "DHARAMPETH";
SELECT * FROM BORROW;
SELECT [Link], [Link] FROM DEPOSIT D JOIN CUSTOMER C ON [Link] =
[Link] WHERE [Link] = "NAGPUR";
SELECT COUNT(DISTINCT CITY) AS TOTAL_BRANCH FROM BRANCH;
SELECT [Link] FROM CUSTOMER C JOIN BRANCH B ON [Link] = [Link]
WHERE [Link] = "BOMBAY" AND [Link] = "NAGPUR";
SELECT [Link] FROM DEPOSIT D JOIN BORROW B ON [Link] = [Link]
WHERE [Link] > 1000 AND [Link] > 2000;
SELECT [Link] FROM DEPOSIT D WHERE [Link] = ( SELECT BNAME FROM
DEPOSIT WHERE CNAME = "SUNIL");
SELECT [Link] FROM BORROW B WHERE [Link] > ( SELECT AMOUNT
FROM BORROW WHERE CNAME = 'PRAMOD');
SELECT [Link] FROM CUSTOMER C WHERE [Link] = ( SELECT [Link] FROM
DEPOSIT D JOIN BRANCH B ON [Link] = [Link] WHERE [Link] =
'SUNIL');
SELECT [Link], [Link], [Link], [Link] FROM BORROW B JOIN
DEPOSIT D ON [Link] = [Link] JOIN CUSTOMER C ON [Link] = [Link]
WHERE [Link] = 'NAGPUR';
SELECT LOANNO, AMOUNT FROM BORROW WHERE BNAME = ( SELECT BNAME
FROM DEPOSIT WHERE CNAME = 'SUNIL');
SELECT [Link], [Link], [Link], [Link] FROM BORROW B JOIN
DEPOSIT D ON [Link] = [Link] JOIN BRANCH BR ON [Link] = [Link]
WHERE [Link] ='BOMBAY';
SELECT [Link], [Link], [Link], [Link], [Link], [Link], [Link]
FROM BORROW B JOIN DEPOSIT D ON [Link] = [Link] JOIN BRANCH BR ON
[Link] = [Link] JOIN CUSTOMER C ON [Link] = [Link] WHERE
[Link] = 'PRAMOD';

You might also like