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
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
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
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education