Question: table [ [ Student , Student _ Course ] , [ StudentID , FirstName,LastName,Gender,Address,,CityofBirth,StudentiD,CourselD,Semester,Grade,Room ] , [ 1 , Ahmed,Abdullah,Male, 1 2 3 Main

\table[[Student,Student_Course],[StudentID,FirstName,LastName,Gender,Address,,CityofBirth,StudentiD,CourselD,Semester,Grade,Room],[1,Ahmed,Abdullah,Male,123 Main St, Gaza City,,Gera,1,1,Fall 2022,85,Room A101],[2,Fatima,,Female,456 Oak St, Ramallah,,Ramallah,1,2,Fall 2022,90,Room B202],[3,Malid,Khalil,Male,789 Pine St, Hebron,,Hebron,2,1,Spring 2023,78,Aocm C303],[4,Lina,Salem,Female,101 Codar St, Nablus,,Nablus,3,3,Fall 2022,92,Room D404],[5,Taria,Hassan,Male,202 Olve St, Bethlehem,,Bethlehem,4,4,Spring 2023,88,Room Es05],[6,Nout,Mahmoud,Female :,303 Walnut St, Jenin,,Jenin,5,3,Fall 2022,82,Room A101],[7,Sare,Ahmad,Female,404 Maple St, Gaza City,,Gaza,6,1,Fall 2022,90,Room B20R],[8,Ornar,Yousef,Male,505 Pine St, Hebron,,Hebron,7,16,Fall 2022,92,Rocm C303],[9,Dina,Rami,Female,606 Birch St, Jerusalem,,Jerusalem,8,17,Spring 2023,75,Room D404],[20,Aya,Omar,Female,202 Al-Mutanabbi St, Shatila, Gaza City,Gaza,9,4,Fall 2022,88,Rloom ESOS],[21,Samir,Fhalid,Male,303 Al-Quds St, AV-Masyoun, Ramallah,Famallah,20,16,Fall 2022,85,Room A101],[,,,,,,20,17,Fall 2022,90,Room B202],[,,,,Course,21,16,Spring 2023,78,Room C303],[,,CourselD,ID Name,Description,isRequired,CreditHours,Price,,],[,,1,Mathematics,Introduction to Mathematics,Mandatory,3,150.00,,],[,,2,Computer Science,Programming Fundamentals,Mandatory,4,200.00,,],[,,3,History,World History,Elective,3,120.00,,],[,,4,Culs331,Cultural Studies,Electivo,3,60.00,,],[,,16,Artificial Intelfigonce,{
\table[[Introduction to AI],[Fundamentals of Data Structures]]},Mandatory,3,200.00,,],[,,17,Data Structures,Mandatory,4,180.00,,]]
Given the data above write SQL queries to answer the following questions:
Print the name of the most expensive course.
How would you change the above query to print the name of the most expensive elective course.
 \table[[Student,Student_Course],[StudentID,FirstName,LastName,Gender,Address,,CityofBirth,StudentiD,CourselD,Semester,Grade,Room],[1,Ahmed,Abdullah,Male,123 Main St, Gaza City,,Gera,1,1,Fall 2022,85,Room A101],[2,Fatima,,Female,456 Oak St, Ramallah,,Ramallah,1,2,Fall 2022,90,Room

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!