Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.
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

Step: 3

blur-text-image

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

Beginning Microsoft SQL Server 2012 Programming

Authors: Paul Atkinson, Robert Vieira

1st Edition

1118102282, 9781118102282

More Books

Students also viewed these Databases questions

Question

Define belongingness, competence, and autonomy.

Answered: 1 week ago

Question

Define indirect financial compensation (employee benefits).

Answered: 1 week ago