Question: table [ [ table [ [ StudentiD ] , [ 1 ] ] , table [ [ FirstName ] , [ Ahmed

\table[[\table[[StudentiD],[1]],\table[[FirstName],[Ahmed]],\table[[LastName],[Abdullah]],Student,,,Student_Course,Room],[Gender A,Address,CityOfBirth,StudentiD,CourselD,Semester,Grade],[Male,123 Main St, Gaza Clty,Gaza,1,1,Fall 2022,85,Room Atot],[2,Fatima:,A is,Fermale 4,456 Oak St, Ramallah,Ramallah,1,2,Fall 2022,90,Room B202],[3,Majid,Khall,Male,789 Pine St, Hebron,Hebron,2,1,Spring 2023,78,Room C303],[4,Lina,Salem,Fernale 10,101 Codar St, Nablus,Nablus,3,3,Fall 2022,92,Room D404],[5,Tariq,Hassan,Male,202 Olive St, Bethlohem,Bethiohem,4,4,Spring 2023,88,Room E505],[6,Nour,Mahmoud,Female 3,303 Walnut St, Jerin,Jenin,5,3,Fall 2022,82,Ploom A101],[7,Sara,Ahmad,Female 40,404 Maple St, Gaza Cly,Gaza,6,1,Fall 2022,80,Aloom B202],[8,Omar,Youset,Male,605 Pine St, Hebron,Hebron,7,16,Fall 2022,92,Rocm C303],[9,Dina,Rami,Female 6,606 Birch St, Jerusalem,Jerusabem,8,17,Spring 2023,75,Room D404],[20,Aya,Omar,Female 2,202 Al-Mutanabbl St, Shatila, Gaza City,Gaza,9,4,Fall 2022,88,Rocm E505],[21,Samir,Khalid,Male,303 Al-Quds St, A-Masyqun, Ramalah,Ramallah,20,16,Fall 2022,85,Rocm A101],[,,,,20,17,Fall 2022,90,Aocm B202],[,,,Course,21,16,Spring 2023,78,Room C303],[,,CourselD,ID Name,Description,isRequired,CreditHours,Price,,],[,,1,Mathemalics,Introduction,to Mathematics,Mandatory,3,150.00,,],[,,2,Computer Science,Programmin,g Fundamentals,Mandatory,4,200.00,,],[,,3,History,World Histor,,Elective,3,120.00,,],[,,4,CULS331,Cultural Stud,dies,Elective,3,60.00,,],[,,16,Artificial Inteligence,Introduction,to Al,Mandatory,3,200.00,,],[,,17,Data Structures,Fundamenta,als of Data Structures,Mandatory,4,180.00,,]]
Given the data above write SQL queries to answer the following questions:
Print the name of students who registered in "Mathematics" course.
Print the name of students who registered in "Mathematics" course and "Computer Science" course
 \table[[\table[[StudentiD],[1]],\table[[FirstName],[Ahmed]],\table[[LastName],[Abdullah]],Student,,,Student_Course,Room],[Gender A,Address,CityOfBirth,StudentiD,CourselD,Semester,Grade],[Male,123 Main St, Gaza Clty,Gaza,1,1,Fall 2022,85,Room Atot],[2,Fatima:,A is,Fermale 4,456 Oak

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!