Display student Marital Status based on a code." (Hint: Use Simple CASE in the SELECT clause. M = Married, S = Single, D = Divorced, W = Widowed) You can find the solution in CH19_Student_Marital_Status (18 rows). 

 

Students Student D StudFirstName StudLast Name Stud Street Address StudCity StudState StudZipCode Stud AresCode StudPhoneNumber StudBirth Date StudGender Stud Marital Status Stud Major Majors Majori Major to Student Schedules Student D ClawD ClassStatus Grade Student Class Status ClassStatus ClassStatusDescription Class Rooms ClassRoom D Building Code PhoneAvailable Capacity Buildings BuildingCode Building Name NumberOfFloors ElevatorAccess SiteParking Available loo ko Classes ClassD SubjectID ClassRoom D Credits SemesterNumber StartDate Start Time Duration MondaySchedule TuesdaySchedule WednesdaySchedule ThursdaySchedule FridaySchedule Saturday Schedule A V Faculty_Classes ClassD Staffi Faculty StaffID Title Status Tenured Faculty Subjects Staff D SubjectID ProficiencyRating Subjects SubjectID Category D SubjectCode SubjectName SubjectPreReg Subject Description SubjectEstClassSize & & 8 00 Staff Staff D StfFirst Name Stfastname StfStreet Address StCity StfState StfZipCode StfAreaCode StiPhoneNumber Salary DateHired Position Faculty Categories Staff D Category D Categories CategoryID Category Description Department D A M Departments Department D DeptName DeptChair