Q1) you have the following table given below: CUSTOMER Customer ID - Gender phone - Address - Account - Balance - Name Email ali.m@gmail.com 077099999999 Iraq/ Mosul current ali.h@gmail.com 077088888888 Iraq/ Mosul current faris.a@gmail.com 075099999999 Iraq/ Basra saving basim@yahoo.com 075088 muna@yahoo.com 078077777777 Iraq/ Erbil mazin@gmail.com 077011111111 Iraq/ Basra 17885 ali mohammed male 2500 16225 ali hadi 20002 faris ali male 4500 male 3100 52355 basim ameen male Iraq /Mosul current 1700 32154 muna ammar female saving 8500 49768 mazin salim male current 1600 huda@yahoo.com 078099999999 Iraq / Erbil mahmod@gmail.com 078055555555 Iraq/ Mosul current jalil.m@yahoo.com 077022222222 Iraq/Basra saving 19283 huda ahmad female saving 6500 76654 mahmod ali male 2000 22445 jalil mazin male 7800 * By using SQL language view: 1- Male customers' information whose balance less than or equal 4500 and accounts are current. 2- Female customers' Names, address who live in Erbil and their balance between (3000 – 5000). 3- Female customers' Names who are use KOREK company on their phone. * How many Records will be appearing after executing the following query? 1- SELECT Name, address, gender FROM CUSTOMER WHERE balance<=2000 AND name like ('*ali* ') ORDER BY name DESC. 2- SELECT address , gender FROM CUSTOMER WHERE address= 'Mosul' ORDER BY name DESC
Q1) you have the following table given below: CUSTOMER Customer ID - Gender phone - Address - Account - Balance - Name Email ali.m@gmail.com 077099999999 Iraq/ Mosul current ali.h@gmail.com 077088888888 Iraq/ Mosul current faris.a@gmail.com 075099999999 Iraq/ Basra saving basim@yahoo.com 075088 muna@yahoo.com 078077777777 Iraq/ Erbil mazin@gmail.com 077011111111 Iraq/ Basra 17885 ali mohammed male 2500 16225 ali hadi 20002 faris ali male 4500 male 3100 52355 basim ameen male Iraq /Mosul current 1700 32154 muna ammar female saving 8500 49768 mazin salim male current 1600 huda@yahoo.com 078099999999 Iraq / Erbil mahmod@gmail.com 078055555555 Iraq/ Mosul current jalil.m@yahoo.com 077022222222 Iraq/Basra saving 19283 huda ahmad female saving 6500 76654 mahmod ali male 2000 22445 jalil mazin male 7800 * By using SQL language view: 1- Male customers' information whose balance less than or equal 4500 and accounts are current. 2- Female customers' Names, address who live in Erbil and their balance between (3000 – 5000). 3- Female customers' Names who are use KOREK company on their phone. * How many Records will be appearing after executing the following query? 1- SELECT Name, address, gender FROM CUSTOMER WHERE balance<=2000 AND name like ('*ali* ') ORDER BY name DESC. 2- SELECT address , gender FROM CUSTOMER WHERE address= 'Mosul' ORDER BY name DESC
Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter12: Database Queries With Sql
Section: Chapter Questions
Problem 3RQ
Related questions
Question
Transcribed Image Text:Q1) you have the following table given below:
CUSTOMER
Customer ID -
Gender
Email
phone - Address - Account - Balance -
Name
ali.m@gmail.com 077099999999 Iraq/ Mosul current
ali.h@gmail.com 077088888888 Iraq/ Mosul current
faris.a@gmail.com 075099999999 Iraq/ Basra saving
basim@yahoo.com 075088888888 Iraq/Mosul current
17885 ali mohammed
male
2500
16225 ali hadi
male
4500
20002 faris ali
male
3100
52355 basim ameen
male
1700
muna@yahoo.com 078077777777 Iraq/ Erbil
mazin@gmail.com 077011111111 Iraq / Basra
huda@yahoo.com 078099999999 Iraq/ Erbil
mahmod@gmail.coI 078055555555 Iraq/Mosul current
jalil.m@yahoo.com 077022222222 Iraq/Basra saving
32154 muna ammar
female
saving
8500
49768 mazin salim
male
current
1600
19283 huda ahmad
female
saving
6500
76654 mahmod ali
male
2000
22445 jalil mazin
male
7800
* By using SQL language view:
1- Male customers' information whose balance less than or equal 4500 and accounts are
current.
2- Female customers' Names, address who live in Erbil and their balance
between (3000 – 5000).
3- Female customers' Names who are use KOREK company on their phone.
* How many Records will be appearing after executing the following query?
1- SELECT Name , address , gender FROM CUSTOMER
WHERE balance <=2000 AND name like (*ali*') ORDER BY name DESC.
2- SELECT address, gender FROM CUSTOMER WHERE address= 'Mosul' ORDER
BY name DESC
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning