Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
11
Reply
How to solve current queries in SQL Server?
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Joe Wilson
9y
722
1
Reply
I have many queries in SQL server which I have problem to solve them please help me to solve them, and I try to write most of the queries by nested queries if it is possible.
1: displaying The customer name and the bank_branch number that customer has received loan from that branch.
2:displaying pair name of customers that received equal amount loan.
3:displaying customer names that have received more than 2 loan .
4: displaying the customer names that their loan's amount is/are more than their account's balance.
5: displaying the number and address of bank_branches which has/have given loan for all of their customers.
6: displaying name and address of banks which all of their branches have given more than 10 loan's for their customers.
7:displaying pair name customers whose phone number start with '383'.
this is my E/R SCHEMA.
Post
Reset
Cancel
Answers (
11
)
Next Recommended Forum
How to solve current queries in SQL Server?
Cannot find one or more components. Please reinstall the app