Answered step by step
Verified Expert Solution
Question
1 Approved Answer
table [ [ table [ [ StudentiD ] , [ 1 ] ] , table [ [ FirstName ] , [ Ahmed
tabletableStudentiDtableFirstNameAhmedtableLastNameAbdullahStudent,,,StudentCourse,RoomGender AAddress,CityOfBirth,StudentiD,CourselD,Semester,GradeMale Main St Gaza CltyGaza,Fall Room AtotFatima:, isFermale Oak St Ramallah,Ramallah,Fall Room BMajid,Khall,Male, Pine St Hebron,Hebron,Spring Room CLina,Salem,Fernale Codar St Nablus,Nablus,Fall Room DTariq,Hassan,Male, Olive St Bethlohem,Bethiohem,Spring Room ENour,Mahmoud,Female Walnut St Jerin,Jenin,Fall Ploom ASara,Ahmad,Female Maple St Gaza ClyGaza,Fall Aloom BOmar,Youset,Male, Pine St Hebron,Hebron,Fall Rocm CDina,Rami,Female Birch St Jerusalem,Jerusabem,Spring Room DAya,Omar,Female AlMutanabbl St Shatila, Gaza City,Gaza,Fall Rocm ESamir,Khalid,Male, AlQuds St AMasyqun, Ramalah,Ramallah,Fall Rocm AFall Aocm BCourse,Spring Room CCourselD,ID Name,Description,isRequired,CreditHours,Price,,Mathemalics,Introduction,to Mathematics,Mandatory,Computer Science,Programmin,g Fundamentals,Mandatory,History,World Histor,,Elective,CULSCultural Stud,dies,Elective,Artificial Inteligence,Introduction,to AlMandatory,Data Structures,Fundamenta,als of Data Structures,Mandatory,
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started