Given the portion of data from the table Patient in the database. Patient_FirstName Patient ID 211347 Eliza 211348 Michael 211349 Ivan 211350 Suhail Patient_LastName Tan Lyod Tan Tan Patient DOB 29-Aug-2017 24-Sept-2016 23-Dec-2016 17-Jul-2015 Patient Address 123, Jalan Bukit Katil, Minden, Penang 87, Tmn Sentapan, Jelutong, Penang 9-2-1, Apartment Jati, Muar, Johor 11, Lebuh Lid, Goergetown, Penang 34a) Write the SQL query to select all columns from the Patient table for rows where the Patient's Last Name is "Tan" for its value. 34b) Based only on the given Patient table and based on the same criteria as above (34a), Write the SQL query to return only the Patient's ID and First Name columns, and who are also from the state of Penang.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%
34
Given the portion of data from the table Patient in the database.
Patient ID
Patient_FirstName
211347
Eliza
211348 Michael
211349 Ivan
211350
Suhail
Patient_LastName
Tan
Lyod
Tan
Tan
Patient_DOB
Patient Address
29-Aug-2017
123, Jalan Bukit Katil, Minden, Penang
24-Sept-2016 87, Tmn Sentapan, Jelutong, Penang
23-Dec-2016 9-2-1, Apartment Jati, Muar, Johor
17-Jul-2015 11, Lebuh Lid, Goergetown, Penang
34a)
Write the SQL query to select all columns from the Patient table for rows where the Patient's Last Name is "Tan" for its value.
34b) Based only on the given Patient table and based on the same criteria as above (34a), Write the SQL query to return only the Patient's ID and First
Name columns, and who are also from the state of Penang.
Transcribed Image Text:34 Given the portion of data from the table Patient in the database. Patient ID Patient_FirstName 211347 Eliza 211348 Michael 211349 Ivan 211350 Suhail Patient_LastName Tan Lyod Tan Tan Patient_DOB Patient Address 29-Aug-2017 123, Jalan Bukit Katil, Minden, Penang 24-Sept-2016 87, Tmn Sentapan, Jelutong, Penang 23-Dec-2016 9-2-1, Apartment Jati, Muar, Johor 17-Jul-2015 11, Lebuh Lid, Goergetown, Penang 34a) Write the SQL query to select all columns from the Patient table for rows where the Patient's Last Name is "Tan" for its value. 34b) Based only on the given Patient table and based on the same criteria as above (34a), Write the SQL query to return only the Patient's ID and First Name columns, and who are also from the state of Penang.
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY