Consider the following two tables: Tablel: Customers customerID Fname 100 101 Lname Amri Kalabani Harthi Alshukaili Rawas City salma@gmail.com Salalah Rami@hotmail.com Sohar Adnan@yahoo.com Sur Amro@gmail.com Bahla Maataz@gmail.com Salalah ZipCode 211 email Salma Rami 205 102 Adnan 201 103 Amro 208 104 Maatz 211 Table2: Orders orderID 1 amount customerID 234$ orderDate 07/04/2019 100 03/14/2020 78$ 103 3 05/23/2019 124$ 102 07/21/2018 25$ 104 6. 11/27/2019 14$ 102 7 12:07/2020 55$ 106 Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it).
Consider the following two tables: Tablel: Customers customerID Fname 100 101 Lname Amri Kalabani Harthi Alshukaili Rawas City salma@gmail.com Salalah Rami@hotmail.com Sohar Adnan@yahoo.com Sur Amro@gmail.com Bahla Maataz@gmail.com Salalah ZipCode 211 email Salma Rami 205 102 Adnan 201 103 Amro 208 104 Maatz 211 Table2: Orders orderID 1 amount customerID 234$ orderDate 07/04/2019 100 03/14/2020 78$ 103 3 05/23/2019 124$ 102 07/21/2018 25$ 104 6. 11/27/2019 14$ 102 7 12:07/2020 55$ 106 Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it).
Chapter9: Joining Data From Multiple Tables
Section: Chapter Questions
Problem 7MC
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
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
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
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