Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions