Write a query to display the record of the person living in Rawalpindi and Karachi? Write a query to display the record of the person whose first name is Ahmed but Last-name doesn’t have Mustafa? Write a query to display the records of last-name whose address contains the word “Gulberg"? customer_id first_name last_name address city state Mustafa 32 Gulshan Iqbal Road Punjab Rawalpindi Punjab Rawalpindi Punjab Islamabad Punjab 1 Ahmed Lahore 2 Karim Khan 4300 Bank Road 931 Gulburg Road |H.No.16, Street 1, H-8/3 Ibrahim 2050 Shahraey Faisal Ahmed Ali 4 Muhammad Hamza 5 Daud Karachi Sindh
Write a query to display the record of the person living in Rawalpindi and Karachi? Write a query to display the record of the person whose first name is Ahmed but Last-name doesn’t have Mustafa? Write a query to display the records of last-name whose address contains the word “Gulberg"? customer_id first_name last_name address city state Mustafa 32 Gulshan Iqbal Road Punjab Rawalpindi Punjab Rawalpindi Punjab Islamabad Punjab 1 Ahmed Lahore 2 Karim Khan 4300 Bank Road 931 Gulburg Road |H.No.16, Street 1, H-8/3 Ibrahim 2050 Shahraey Faisal Ahmed Ali 4 Muhammad Hamza 5 Daud Karachi Sindh
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 93C
Related questions
Question
100%
![Write a query to display the record of the person living in Rawalpindi and Karachi?
Write a query to display the record of the person whose first name is Ahmed but Last-name doesn't
have Mustafa?
Write a query to display the records of last-name whose address contains the word "Gulberg"?
customer_id first_name last_name
address
city
state
Mustafa 32 Gulshan Iqbal Road
Punjab
Rawalpindi Punjab
Rawalpindi Punjab
Punjab
1
Ahmed
Lahore
2
Karim
Khan
4300 Bank Road
Ali
931 Gulburg Road
H.No.16, Street 1, H-8/3
2050 Shahraey Faisal
Ahmed
4
Muhammad
Hamza
Islamabad
5
Daud
Ibrahim
Karachi
Sindh](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe6baa31b-68f4-4070-92de-7808be3ba002%2F8fc81c00-b720-4aad-bcb3-4a49064fff96%2F489fjd_processed.png&w=3840&q=75)
Transcribed Image Text:Write a query to display the record of the person living in Rawalpindi and Karachi?
Write a query to display the record of the person whose first name is Ahmed but Last-name doesn't
have Mustafa?
Write a query to display the records of last-name whose address contains the word "Gulberg"?
customer_id first_name last_name
address
city
state
Mustafa 32 Gulshan Iqbal Road
Punjab
Rawalpindi Punjab
Rawalpindi Punjab
Punjab
1
Ahmed
Lahore
2
Karim
Khan
4300 Bank Road
Ali
931 Gulburg Road
H.No.16, Street 1, H-8/3
2050 Shahraey Faisal
Ahmed
4
Muhammad
Hamza
Islamabad
5
Daud
Ibrahim
Karachi
Sindh
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 6 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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 Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr