Question: Write the SQL queries for the following: a) (3 points). Retrieve the last and first names of Math students b) (3 points). Find all different

 Write the SQL queries for the following: a) (3 points). Retrieve

the last and first names of Math students b) (3 points). Find

Write the SQL queries for the following: a) (3 points). Retrieve the last and first names of Math students b) (3 points). Find all different grades. c)(3 points). Retrieve department names that have '2' as the second character in Courld. d) (3 points). Sort StudID and CourID in ascending and descending orders respectively. e) (3 points). What is the total point value of the courses in the COMP dept? f)(3 points). How many different first names do COMP majors have? 0 the belonen Student LName FName Studia Grades Major Studio Courid Grade Susan A+ Smith Bond Smith James 131313 Comp 007007 Math 555555 Comp 010101 Math C 302 C302 Susan 007007 555555 007007 007007 A Cecil John C301 M214 C 201 A+ Course PName Couria 131313 Points 555555 15 DB Sys C302 SofEng C301 DisMat M214 Pr&.Sys C201 Depr Comp Comp Math Comp 131313 007007 15 C 201 C302 C 201 C 201 1088 22 010101 22

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!