Page 1 of 1
34 Given the portion of data from the table Patient in the database. Patient_FirstName Patient ID 211347 Eliza 211348 Mi
Posted: Fri Jul 08, 2022 6:35 am
by answerhappygod
- 34 Given The Portion Of Data From The Table Patient In The Database Patient Firstname Patient Id 211347 Eliza 211348 Mi 1 (76.51 KiB) Viewed 32 times
34 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 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. (4marks) 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. (7marks)